Файл: Install SQL/new_install.sql
Строк: 8002
-- phpMyAdmin SQL Dump
-- version 4.4.15.10
--
https://www.phpmyadmin.net
--
-- Хост: localhost
-- Время
создания: Апр 01 2018 г., 11:30
-- Версия сервера:
5.5.52-MariaDB-cll-lve
-- Версия PHP: 5.4.16
SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8mb4 */;
--
-- База данных: `u11763_wallet2`
--
--
--------------------------------------------------------
--
--
Структура таблицы `captcha`
--
CREATE TABLE IF NOT EXISTS
`captcha` (
`captcha_id` bigint(13) unsigned NOT NULL,
`captcha_time`
int(10) unsigned NOT NULL,
`ip_address` varchar(16) NOT NULL DEFAULT
'0',
`word` varchar(20) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=117
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `carts`
--
CREATE TABLE IF NOT EXISTS
`carts` (
`id` int(10) unsigned NOT NULL,
`id_item` int(10) NOT NULL,
`id_merchant` int(10) NOT NULL,
`user` varchar(200) NOT NULL,
`date`
datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `ci_sessions`
--
CREATE TABLE IF NOT
EXISTS `ci_sessions` (
`id` varchar(128) NOT NULL,
`ip_address`
varchar(45) NOT NULL,
`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
`data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `currencys`
--
CREATE TABLE IF NOT
EXISTS `currencys` (
`id` int(11) NOT NULL,
`base_name` varchar(256)
NOT NULL,
`base_code` varchar(128) NOT NULL,
`extra1_check` int(11) NOT
NULL,
`extra1_name` varchar(256) NOT NULL,
`extra1_code` varchar(128)
NOT NULL,
`extra1_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
`extra2_check` int(11) NOT NULL,
`extra2_name` varchar(256) NOT NULL,
`extra2_code` varchar(256) NOT NULL,
`extra2_rate` decimal(10,2) NOT NULL
DEFAULT '0.00',
`extra3_check` int(11) NOT NULL,
`extra3_name`
varchar(256) NOT NULL,
`extra3_code` varchar(128) NOT NULL,
`extra3_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
`extra4_check`
int(11) NOT NULL,
`extra4_name` varchar(256) NOT NULL,
`extra4_code`
varchar(128) NOT NULL,
`extra4_rate` decimal(10,2) NOT NULL DEFAULT
'0.00',
`extra5_check` int(11) NOT NULL,
`extra5_name` varchar(256) NOT
NULL,
`extra5_code` varchar(128) NOT NULL,
`extra5_rate` decimal(10,2)
NOT NULL DEFAULT '0.00',
`fee` decimal(10,2) NOT NULL,
`fee_fix`
decimal(10,2) NOT NULL,
`api_extra1` enum('0','1') NOT NULL,
`api_extra2` enum('0','1') NOT NULL,
`api_extra3` enum('0','1') NOT
NULL,
`api_extra4` enum('0','1') NOT NULL,
`api_extra5` enum('0','1')
NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
--
Дамп данных таблицы `currencys`
--
INSERT INTO
`currencys` (`id`, `base_name`, `base_code`, `extra1_check`, `extra1_name`,
`extra1_code`, `extra1_rate`, `extra2_check`, `extra2_name`, `extra2_code`,
`extra2_rate`, `extra3_check`, `extra3_name`, `extra3_code`, `extra3_rate`,
`extra4_check`, `extra4_name`, `extra4_code`, `extra4_rate`,
`extra5_check`, `extra5_name`, `extra5_code`, `extra5_rate`, `fee`,
`fee_fix`, `api_extra1`, `api_extra2`, `api_extra3`, `api_extra4`,
`api_extra5`) VALUES
(1, 'American dollar', 'USD', 1, 'Russian Ruble',
'RUB', 51.99, 1, 'Euro', 'EUR', 0.65, 1, 'Grivna Ukraine', 'UAH', 1.50, 1,
'Chine Wallet', 'CNY', 18.00, 1, 'Pounds Sterling', 'GBP', 980.00, 1.00,
0.50, '1', '1', '0', '1', '1');
--
--------------------------------------------------------
--
--
Структура таблицы `disputes`
--
CREATE TABLE IF NOT EXISTS
`disputes` (
`id` int(10) unsigned NOT NULL,
`transaction` int(10) NOT
NULL,
`time_transaction` datetime NOT NULL,
`time_dispute` datetime NOT
NULL,
`claimant` varchar(200) NOT NULL,
`defendant` varchar(200) NOT
NULL,
`status` enum('1','2','3','4') NOT NULL,
`amount` decimal(10,2)
NOT NULL,
`fee` decimal(10,2) NOT NULL,
`sum` decimal(10,2) NOT NULL,
`currency` varchar(200) NOT NULL,
`title` enum('1','2') NOT NULL,
`message` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `disputes_comment`
--
CREATE TABLE IF
NOT EXISTS `disputes_comment` (
`id` int(10) unsigned NOT NULL,
`id_dispute` int(10) NOT NULL,
`time` datetime NOT NULL,
`user`
varchar(200) NOT NULL,
`role` enum('1','2','3','4','5') NOT NULL,
`comment` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `emails`
--
CREATE TABLE IF NOT EXISTS
`emails` (
`id` int(10) unsigned NOT NULL,
`name` varchar(64) NOT
NULL,
`email` varchar(256) NOT NULL,
`title` varchar(128) NOT NULL,
`message` text NOT NULL,
`created` datetime NOT NULL,
`read` datetime
DEFAULT NULL,
`read_by` int(11) unsigned DEFAULT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `email_templates`
--
CREATE TABLE IF NOT
EXISTS `email_templates` (
`id` int(10) unsigned NOT NULL,
`title` text
NOT NULL,
`message` text NOT NULL,
`status` enum('0','1') NOT NULL
)
ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
--
-- Дамп
данных таблицы `email_templates`
--
INSERT INTO
`email_templates` (`id`, `title`, `message`, `status`) VALUES
(1, 'Confirm
registration', '<meta http-equiv="Content-Type"
content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Account
registration</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Confirm
account!</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]<br
/>\r\n <br />\r\n Thank you for creating an account at
[SITE_NAME]. Click the link below to validate your email address and
activate your
account.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[CHECK_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">Confirm
email</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(2, 'Signed in', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\n<title></title>\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\n\n @media only screen and (min-width: 640px) {\n
*[class].wrapper { width: 480px !important; }\n
*[class].wrapper__indent { width: 60px !important;
}\n }\n</style>\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\n <tbody>\n <tr>\n <td>\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\n <tbody>\n <tr>\n <td
align="center" height="45"
valign="middle">\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Signing
in to your
account</p>\n </td>\n </tr>\n </tbody>\n </table>\n\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\n <tbody>\n <tr>\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;" width="30"> </td>\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\n </tr>\n <tr>\n <td> </td>\n <td>\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear, [NAME]!<br
/>\n <br />\n You or someone else has logged into your
account. If you did not attempt to access your account and think that it
was someone else, it's best to change your password to access the
account.</p>\n\n <p style="color: #303030; font:
18px/20px Helvetica, Arial, sans-serif; margin: 25px 0 25px 0; text-align:
center;"><strong>IP address
[IP_ADDRESS]</strong></p>\n </td>\n <td> </td>\n </tr>\n <tr>\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\n <td style="border-top: 0px
solid #dee0e1; ">\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[ACCOUNT_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\n </td>\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\n </tr>\n </tbody>\n </table>\n\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\n <tbody>\n <tr>\n <td
align="center" height="45"
valign="middle">\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\n [SITE_NAME]</p>\n </td>\n </tr>\n </tbody>\n </table>\n </td>\n </tr>\n </tbody>\n</table>\n<!--//
100% body table -->', '1'),
(3, 'Reset password', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important; }\r\n
}\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Reset
password</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Hello!<br
/>\r\n <br />\r\n Your password at [SITE_NAME] has been
reset. Click the link below to log in with your new
password.</p>\r\n\r\n <p style="color: #303030; font:
18px/20px Helvetica, Arial, sans-serif; margin: 25px 0 25px 0; text-align:
center;"><strong>[PASSWORD]</strong></p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[ACCOUNT_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n',
'1'),
(4, 'Create ticket', '<meta http-equiv="Content-Type"
content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Support
message</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>New
ticket</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n For you a new ticket has been created
on the site
[SITE_NAME].</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[TICKET_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">Read
message</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(5, 'New comment in ticket', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Support
message</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>New
comment</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n A new comment is available for the
ticket
[CODE_TICKET].</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[TICKET_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">Read
message</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(6, 'Ticket closed', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Support
message</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Ticket
closed</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n Ticket [CODE_TICKET] was
closed and unavailable for
comment.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[TICKET_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">See
ticket</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(7, 'Verification request verified',
'<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Account
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Your account is
verified</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n Your account has been successfully
verified. You can use your account without
restrictions!</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(8, 'Verification request rejected',
'<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Account
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#F44336;"> </td>\r\n <td
align="center" bgcolor="#F44336" height="50"
style="background: #F44336;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Verification request
rejected</strong></p>\r\n </td>\r\n <td
style="background:
#F44336;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n We checked your documents and could
not verify your account. Reason for
rejection:</p>\r\n\r\n <p style="color: #303030; font:
15px/20px Helvetica, Arial, sans-serif; margin: 25px 0 25px 0; text-align:
center;"><strong>[COMMENT]</strong></p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(9, 'Notice to receive', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin:
0px;">Transaction
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Notice to
receive</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n The funds amount equal to [SUM] [CUR]
were received on your account. You can see details of the transaction after
sign in your
account!</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">Transactions</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(10, 'Withdrawal pending!', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin:
0px;">Transaction
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Withdrawal
pending</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n The withdrawal, amount equal to [SUM]
[CUR], were deducted from your account. Time of execution depends on the
type of withdrawal you
chosen.!</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">Transactions</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(11, 'Completed currency exchange!',
'<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin:
0px;">Transaction
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Completed currency
exchange</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n You successfully exchanged [SUM_1]
[CUR_1] on [SUM_2] [CUR_2]. You can checked the current balance
and transaction history after log in your
account.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(12, 'Open dispute!', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Dispute
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Open
dispute</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n User [CLAIMANT] opened a
dispute about the transaction ID [ID_TRANSACTION]. Check out the
subject of the dispute and give your
answer.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(13, 'New comment for dispute', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Dispute
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>New comment for
dispute</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n New comment was added for the dispute
ID [ID_DISPUTE]. You can read it after log in the
account.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(14, 'Claim opened!', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Dispute
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Claim
opened!</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n Your dispute ID [ID_DISPUTE] was
transferred to the
claim!</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1');
INSERT INTO `email_templates` (`id`,
`title`, `message`, `status`) VALUES
(15, 'Claim rejected', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Dispute
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Claim
rejected</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n After a thorough analysis of the
evidence provided by ID [ID_DISPUTE], we have completed the investigation
and decided in favor of the
seller.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(18, 'Documents received for review',
'<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Account
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Documents received for
review</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n Your account has been successfully
verified. You can use your account without
restrictions!</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(21, 'Claim satisfied', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Dispute
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Claim
satisfied</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n After a thorough analysis of the
evidence provided in the dispute ID [ID_DISPUTE], we completed the
investigation and decided in favor of the sender of payment. Money was
returned by transaction ID
[ID_TRANSACTION].</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(25, 'Success money transfer', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin:
0px;">Transaction
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Success money
transfer</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n You have successfully transferred
[SUM] [CUR] to the user [RECEIVER]. You can see the
details transaction in your
account.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(26, 'Withdrawal is confirmed', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Account
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Withdrawal is
confirmed</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n The withdrawal of funds in the amount
of [SUM] [CUR] was confirmed by the
administrator.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(27, 'Withdrawal of funds denied', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin:
0px;">Transaction
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#F44336;"> </td>\r\n <td
align="center" bgcolor="#F44336" height="50"
style="background: #F44336;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Withdrawal of funds
denied</strong></p>\r\n </td>\r\n <td
style="background:
#F44336;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n The withdrawal of funds in the amount
of [SUM] [CUR] was rejected by the administrator. Funds refund to your
account.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(28, 'Invoice pending', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Invoice
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Invoice
pending</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n Received new invoice for the amount of
[SUM] [CUR]. You can pay the invoice or
reject.</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(29, 'Invoice rejected', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Invoice
status</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>Invoice
rejected</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]!<br
/>\r\n <br />\r\n The invoice ID
[ID_INVOICE] was
rejected..</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[SITE_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(30, 'New message', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">New
message</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td
style="background:
#ffc107;"> </td>\r\n <td
align="center" bgcolor="#ffc107" height="50"
style="background: #ffc107;">\r\n <p style="font:
17px/20px Helvetica, Arial, sans-serif; color:
#ffffff;"><strong>[TITLE]</strong></p>\r\n </td>\r\n <td
style="background:
#ffc107;"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear [NAME]<br
/>\r\n <br
/>\r\n [MESSAGE]</p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0
25px;"> </p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1'),
(31, 'Confirm login', '<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8">\r\n<title></title>\r\n<style
type="text/css">a:hover { text-decoration: underline
!important; }\r\n\r\n @media only screen and (min-width: 640px) {\r\n
*[class].wrapper { width: 480px !important; }\r\n
*[class].wrapper__indent { width: 60px !important;
}\r\n }\r\n</style>\r\n<table bgcolor="#ebedef"
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/24px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 0px;">Signing
in to your
account</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
align="center" bgcolor="#ffffff" border="0"
cellpadding="0" cellspacing="0"
class="wrapper" style="background-color: #ffffff; border:
1px solid #c8cace; border-radius: 4px; margin: auto;"
width="480">\r\n <tbody>\r\n <tr>\r\n <td
class="wrapper__indent" style="border-bottom: 1px solid
#wwwwww;"
width="30"> </td>\r\n <td
align="center" height="70" style="border-bottom:
1px solid #wwwwww;" valign="middle"><a
alias="site_logo" href="#"
target="_blank"><img alt=""
src="https://justwallet.pw/themes/default/img/logo.png"
style="display: block;" width="200" />
</a></td>\r\n <td class="wrapper__indent"
style="border-bottom: 1px solid #wwwwww;"
width="30"> </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td>\r\n <p
style="color: #303030; font: 15px/20px Helvetica, Arial, sans-serif;
margin: 25px 0 25px 0; text-align: center;">Dear, [NAME]!<br
/>\r\n <br />\r\n Someone is trying to enter your
account. If this is you, enter this code on the authentication
page:</p>\r\n\r\n <p style="color: #303030; font:
18px/20px Helvetica, Arial, sans-serif; margin: 25px 0 25px 0; text-align:
center;"><strong>[CODE]</strong></p>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <tr>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n <td style="border-top: 0px
solid #dee0e1; ">\r\n <p align="center"
style="margin: 10px 0 25px;"><a alias="button"
href="[ACCOUNT_LINK]" style="text-decoration: none; font:
17px/40px Helvetica, Arial, sans-serif; color: #ffffff; display: block;
width: 225px; background: #28a745; border-radius: 4px;"
target="_blank">My
account</a></p>\r\n </td>\r\n <td
style="border-top: 0px solid #dee0e1;
"> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n\r\n <table
border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse;"
width="100%">\r\n <tbody>\r\n <tr>\r\n <td
align="center" height="45"
valign="middle">\r\n <p style="font: 13px/20px
Arial, sans-serif, Helvetica; color: #939aa4; margin: 20px 0
0;">Have a questions? Write to the Support Service.<br
/>\r\n [SITE_NAME]</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<!--//
100% body table -->', '1');
--
--------------------------------------------------------
--
--
Структура таблицы `events`
--
CREATE TABLE IF NOT EXISTS
`events` (
`id` int(10) unsigned NOT NULL,
`type`
enum('1','2','3','4','5','6') NOT NULL,
`user` varchar(100) NOT NULL,
`ip` varchar(100) NOT NULL,
`date` datetime NOT NULL,
`code`
varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=284 DEFAULT
CHARSET=utf8;
--
-- Дамп данных таблицы
`events`
--
INSERT INTO `events` (`id`, `type`, `user`, `ip`, `date`,
`code`) VALUES
(282, '1', 'admin', '109.106.142.195', '2018-04-01
10:28:29', 'evn_5ac0a63dc92ba'),
(283, '1', 'admin', '109.106.142.195',
'2018-04-01 10:29:41', 'evn_5ac0a6852fd15');
--
--------------------------------------------------------
--
--
Структура таблицы `invoices`
--
CREATE TABLE IF NOT EXISTS
`invoices` (
`id` int(10) unsigned NOT NULL,
`code` varchar(100) NOT
NULL,
`date` datetime NOT NULL,
`name` text NOT NULL,
`info` text NOT
NULL,
`amount` decimal(10,2) NOT NULL,
`fee` decimal(10,2) NOT NULL,
`total` decimal(10,2) NOT NULL,
`currency` varchar(100) NOT NULL,
`sender` varchar(200) NOT NULL,
`receiver` varchar(200) NOT NULL,
`status` enum('1','2','3') NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=12
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `items`
--
CREATE TABLE IF NOT EXISTS
`items` (
`id` int(100) unsigned NOT NULL,
`name` text NOT NULL,
`about` text NOT NULL,
`category_id` int(10) NOT NULL,
`merchant_id`
int(10) NOT NULL,
`availability` int(10) NOT NULL,
`img` text NOT
NULL,
`download_link` text NOT NULL,
`status` enum('1','2','3') NOT
NULL,
`user` varchar(100) NOT NULL,
`price` decimal(10,2) NOT NULL,
`currency` varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `login_attempts`
--
CREATE TABLE IF NOT
EXISTS `login_attempts` (
`ip` varchar(20) NOT NULL,
`attempt` datetime
NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `login_attempts`
--
INSERT INTO `login_attempts` (`ip`,
`attempt`) VALUES
('109.106.142.195', '2018-04-01 10:29:40');
--
--------------------------------------------------------
--
--
Структура таблицы `merchants`
--
CREATE TABLE IF NOT
EXISTS `merchants` (
`id` int(10) unsigned NOT NULL,
`date` datetime
NOT NULL,
`name` text NOT NULL,
`user` varchar(300) NOT NULL,
`link`
text NOT NULL,
`status_link` text NOT NULL,
`success_link` text NOT
NULL,
`fail_link` text NOT NULL,
`password` text NOT NULL,
`status`
enum('1','2','3') NOT NULL,
`comment` text NOT NULL,
`logo` text NOT
NULL,
`category` varchar(200) NOT NULL,
`show_category` enum('0','1')
NOT NULL,
`note_payment` text NOT NULL,
`fee` decimal(10,2) NOT NULL,
`fix_fee` decimal(10,2) NOT NULL,
`payeer_fee` enum('0','1') NOT NULL,
`test_mode` enum('0','1') NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `merchants_categories`
--
CREATE TABLE
IF NOT EXISTS `merchants_categories` (
`id` int(10) unsigned NOT NULL,
`id_merchant` int(10) NOT NULL,
`name` text NOT NULL,
`status`
enum('1','2') NOT NULL,
`user` varchar(200) NOT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `merchant_categories`
--
CREATE TABLE IF
NOT EXISTS `merchant_categories` (
`id` int(10) unsigned NOT NULL,
`code` varchar(100) NOT NULL,
`date` datetime NOT NULL,
`status`
enum('0','1') NOT NULL,
`name` text NOT NULL,
`img` text NOT NULL
)
ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `orders`
--
CREATE TABLE IF NOT EXISTS
`orders` (
`id` int(10) unsigned NOT NULL,
`code` varchar(100) NOT
NULL,
`date` datetime NOT NULL,
`id_item` int(10) NOT NULL,
`id_merchant` int(10) NOT NULL,
`id_transaction` int(10) NOT NULL,
`user` varchar(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `pages`
--
CREATE TABLE IF NOT EXISTS
`pages` (
`id` int(10) NOT NULL,
`name` text NOT NULL,
`content` text
NOT NULL,
`translite` enum('0','1') NOT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `pages`
--
INSERT INTO `pages` (`id`, `name`, `content`,
`translite`) VALUES
(1, 'Home',
'a:7:{s:5:"dutch";s:12:"<p>dutch</p>";s:7:"english";s:7142:"<div
class="landing">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-5
mt-6">\r\n<h4>Simple money transfers around
world</h4>\r\n\r\n<p>Universal solutions for receiving payments
and purchases. There is nothing easier! Register an account today and see
for yourself!</p>\r\n</div>\r\n</div>\r\n\r\n<div
class="row mt-2">\r\n<div
class="col-md-5"><a class="btn btn-outline-light
btn-lg" href="#">Sign in</a> <a class="btn
btn-success btn-lg" href="#">Create
account</a></div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-12
mt-5">\r\n<h2 class="text-center">You can send and
receive payments</h2>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-5">\r\n<div
class="text-center"><img alt=""
class="w-25"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/user.png"
/>\r\n<h5 class="mt-3">Mulricurrency
account</h5>\r\n\r\n<p class="mt-3">Keep money in
local currency and transfer money to any country only by
username</p>\r\n<a class="btn btn-outline-secondary"
href="#">Learn
more</a></div>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-5">\r\n<div
class="text-center"><img alt=""
class="w-25"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/shop.png"
/>\r\n<h5 class="mt-3">Merchant
integration</h5>\r\n\r\n<p class="mt-3">Accept
payments on your site using a simple HTML form and IPM
notifications</p>\r\n<a class="btn
btn-outline-secondary" href="#">Learn
more</a></div>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-5">\r\n<div
class="text-center"><img alt=""
class="w-25"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/lock.png"
/>\r\n<h5 class="mt-3">Protect
purchase</h5>\r\n\r\n<p class="mt-3">Buy goods and
pay for services, and if something goes wrong, we will refund
money</p>\r\n<a class="btn btn-outline-secondary"
href="#">Learn
more</a></div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="top-merchant mt-5">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-12 mt-5
mb-5">\r\n<h2 class="text-center">Just Wallet
unites buyers and sellers around the
world</h2>\r\n</div>\r\n\r\n<div
class="col-md-12">\r\n<div
class="text-center">\r\n<div aria-label="Basic
example" class="btn-group" role="group"><a
aria-controls="nav-home" aria-selected="true"
class="btn btn-outline-success" data-toggle="tab"
href="#nav-home" id="nav-home-tab"
role="tab">For buyers</a> <a
aria-controls="nav-profile" aria-selected="false"
class="btn btn-outline-success" data-toggle="tab"
href="#nav-profile" id="nav-profile-tab"
role="tab">For
sellers</a></div>\r\n</div>\r\n</div>\r\n\r\n<div
class="col-md-12">\r\n<div class="tab-content"
id="nav-tabContent">\r\n<div
aria-labelledby="nav-home-tab" class="tab-pane fade show
active" id="nav-home"
role="tabpanel">\r\n<div
class="row">\r\n<div class="col-md-4
mt-5">\r\n<div class="row">\r\n<div
class="col-md-12">\r\n<div
class="text-center"><img alt=""
class="w-75"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/payer1.png"
/></div>\r\n</div>\r\n\r\n<div class="col-md-2
mt-4"><span
class="step-badge">1</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p><a
href="#">Sign in</a> to your account or sign in if you
do not already have
one</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-5">\r\n<div
class="row">\r\n<div
class="col-md-12">\r\n<div
class="text-center"><img alt=""
class="w-75"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/payer2.png"
/></div>\r\n</div>\r\n\r\n<div class="col-md-2
mt-4"><span
class="step-badge-2">2</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p>Add funds to your account
through a convenient deposit
method</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-5">\r\n<div
class="row">\r\n<div
class="col-md-12">\r\n<div
class="text-center"><img alt=""
class="w-75"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/payer3.png"
/></div>\r\n</div>\r\n\r\n<div class="col-md-2
mt-4"><span
class="step-badge-2">3</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p>Pay for the purchase
simply by entering your username and
password</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
aria-labelledby="nav-profile-tab" class="tab-pane"
id="nav-profile" role="tabpanel">\r\n<div
class="row">\r\n<div class="col-md-4
mt-5">\r\n<div class="row">\r\n<div
class="col-md-12">\r\n<div
class="text-center"><img alt=""
class="w-75"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/seller2.png"
/></div>\r\n</div>\r\n\r\n<div class="col-md-2
mt-4"><span
class="step-badge">1</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p>Perform simple account
verification so that customers can trust
you</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-5">\r\n<div
class="row">\r\n<div
class="col-md-12">\r\n<div
class="text-center"><img alt=""
class="w-75"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/seller1.png"
/></div>\r\n</div>\r\n\r\n<div class="col-md-2
mt-4"><span
class="step-badge-2">2</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p>Create a new merchant and
mindset of integration with your
site</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-5">\r\n<div
class="row">\r\n<div
class="col-md-12">\r\n<div
class="text-center"><img alt=""
class="w-75"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/seller3.png"
/></div>\r\n</div>\r\n\r\n<div class="col-md-2
mt-4"><span
class="step-badge-2">3</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p>Publish HTML form on your
website and start receiving
payments</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="col-md-12 mt-4 mb-5">\r\n<div
class="text-center"><a class="btn btn-secondary
btn-lg" href="#">Documentation for
developers</a></div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="foot-merchant">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-12
mt-5">\r\n<h2 class="text-center text-white">Join
thousands of Just Wallet users around the
world</h2>\r\n</div>\r\n</div>\r\n\r\n<div
class="row">\r\n<div class="col-md-3 mt-5
mb-5">\r\n<h5 class="text-center text-white">Safe
and secure</h5>\r\n\r\n<p class="text-center
text-white">Buy and do not worry about the consequences. If you do
not receive the goods we will refund the money to your
account!</p>\r\n</div>\r\n\r\n<div class="col-md-3 mt-5
mb-5">\r\n<h5 class="text-center
text-white">Invoice system</h5>\r\n\r\n<p
class="text-center text-white">Issue bills to your customers,
get paid and withdraw funds from your account in convenient payment
directions!</p>\r\n</div>\r\n\r\n<div class="col-md-3
mt-5 mb-5">\r\n<h5 class="text-center
text-white">Shops and payment</h5>\r\n\r\n<p
class="text-center text-white">Pay for goods and services on
the site. Choose a store, enter a note for payment and make a paymentю
It's fast and safe!</p>\r\n</div>\r\n\r\n<div
class="col-md-3 mt-5 mb-5">\r\n<h5 class="text-center
text-white">Exchange currency</h5>\r\n\r\n<p
class="text-center text-white">Exchange and store different
currencies in one purse. You will be pleasantly surprised by the exchange
rate of
currencies!</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="top-merchant">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-12
mt-5">\r\n<h4 class="text-center">Create account
and get started</h4>\r\n</div>\r\n\r\n<div
class="col-md-12 mt-4 mb-5">\r\n<h4
class="text-center"><a class="btn btn-success
btn-lg" href="#">Sign up
now</a></h4>\r\n</div>\r\n</div>\r\n</div>\r\n</div>";s:10:"indonesian";s:17:"<p>indonesian</p>";s:7:"russian";s:89:"<p>русиянский
язык в действии вуаяля тратата
ым</p>";s:18:"simplified-chinese";s:16:"<p>chine
erg</p>";s:7:"spanish";s:14:"<p>spanish</p>";s:7:"turkish";s:14:"<p>turkish</p>";}',
'1'),
(2, 'How it works',
'a:7:{s:5:"dutch";s:12:"<p>dutch</p>";s:7:"english";s:3939:"<div
class="landing-2">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-5
mt-6">\r\n<h4>Purchase in two
clicks</h4>\r\n\r\n<p>Pay in hundreds of stores - you only need
to enter your login and password from your account! If something goes wrong
- we will refund the
money!</p>\r\n</div>\r\n</div>\r\n\r\n<div
class="row mt-2">\r\n<div
class="col-md-5"><a class="btn btn-outline-light
btn-lg" href="#">Sign in</a> <a class="btn
btn-success btn-lg" href="#">Shops and
payment</a></div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="top-protect">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-4 mt-3
mb-3">\r\n<div class="row">\r\n<div
class="col-md-2 mt-4"><span
class="top-badge">1</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p
class="text-white">Safe shopping around the world in different
currencies</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-3 mb-3">\r\n<div
class="row">\r\n<div class="col-md-2
mt-4"><span
class="top-badge-2">2</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p
class="text-white">Do not need to enter card data - just sign
in Just
Wallet</p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="col-md-4 mt-3 mb-3">\r\n<div
class="row">\r\n<div class="col-md-2
mt-4"><span
class="top-badge-2">3</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p
class="text-white">Save time - order in two clicks without
superfluous
forms</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-12 mt-5
mb-5">\r\n<div class="text-center"><img
alt="" class="w-10"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/ok.png"
/></div>\r\n\r\n<h2 class="text-center">Your
private information is not disclosed.</h2>\r\n\r\n<h5
class="text-center text-muted">For payment, you only need to
enter your e-mail address and password. Billing data is stored in your
account and not sent to the
merchant.</h5>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="landing-3">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-7
mt-6"> </div>\r\n\r\n<div class="col-md-5
mt-6">\r\n<h4>Shopping in stores of any
country</h4>\r\n\r\n<p>Pay for purchases in 5 different
currencies with zero and minimum commission. You can make purchases in your
account or on the seller's website!</p>\r\n<a
class="btn btn-light btn-lg" href="#">Store
explorer</a></div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="top-merchant">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-12 mt-5
mb-5">\r\n<h2 class="text-center">We are unhappy
with the purchase?</h2>\r\n</div>\r\n\r\n<div
class="col-md-6 mt-1 mb-5"><img alt=""
class="w-100"
src="http://justbtc.ideah.ru/assets/themes/escrow/img/dispute2.png"
/></div>\r\n\r\n<div class="col-md-6 mt-1
mb-5">\r\n<div class="row">\r\n<div
class="col-md-2 mt-4"><span
class="step-badge">1</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p>Open a dispute with the
seller and describe the cause of dissatisfaction. Seller will receive your
payment and be able to return the money to your
account.</p>\r\n</div>\r\n</div>\r\n\r\n<div
class="row">\r\n<div class="col-md-2
mt-4"><span
class="step-badge-2">2</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p>If you can not agree -
start a claim. We will get acquainted with the problem and contact the
seller. Be sure we will conduct a detailed investigation of the
problem.</p>\r\n</div>\r\n</div>\r\n\r\n<div
class="row">\r\n<div class="col-md-2
mt-4"><span
class="step-badge-2">3</span></div>\r\n\r\n<div
class="col-md-10 mt-3">\r\n<p>We will make a fair
decision in a short time and return the money to your account. The refund
can be executed in full or in
part.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="foot-merchant">\r\n<div
class="container">\r\n<div
class="row">\r\n<div class="col-md-12
mt-6">\r\n<h4 class="text-center text-white">Create
account and get started</h4>\r\n</div>\r\n\r\n<div
class="col-md-12 mt-4 mb-5">\r\n<h4
class="text-center"><a class="btn btn-outline-light
btn-lg" href="#">Sign
up</a></h4>\r\n</div>\r\n</div>\r\n</div>\r\n</div>";s:10:"indonesian";s:17:"<p>indonesian</p>";s:7:"russian";s:56:"<p>русиянский
язык в
действии</p>";s:18:"simplified-chinese";s:16:"<p>chine
erg</p>";s:7:"spanish";s:14:"<p>spanish</p>";s:7:"turkish";s:14:"<p>turkish</p>";}',
'1'),
(3, 'For developers',
'a:7:{s:5:"dutch";s:12:"<p>dutch</p>";s:7:"english";s:13526:"<?php
defined(''BASEPATH'') OR exit(''No direct script access allowed'');
?>\r\n\r\n<div class="header-st mb-head">\r\n <div
class="container">\r\n <div
class="row">\r\n <div
class="col-md-2">\r\n \r\n
</div>\r\n <div class="col-md-8 col-sm-6
col-xs-7">\r\n <div class="code-editor">\r\n
<div class="tabs">\r\n <div
class="title -javascript"><i class="icon
devicon-javascript-plain colored"></i>For
developers</div>\r\n </div>\r\n
<div class="content">\r\n <ul
class="lines">\r\n <li
class="line"><span
class="linenumber">1</span>\r\n
<span class="comment">// Publish on your
site</span>\r\n </li>\r\n
<li class="line"><span
class="linenumber">2</span><span
class="yellow"><form method="POST"
action="http://justbtc.ideah.ru/sci/form"
target="_blank"></span></li>\r\n
<li class="line"><span
class="linenumber">3</span><span
class="red"> <input type="hidden"
name="merchant" value="7">
</span></li>\r\n <li
class="line"><span
class="linenumber">4</span><span
class="red"> <input type="hidden"
name="item_name" value="Testing
payment"></span></li>\r\n <li
class="line"><span
class="linenumber">5</span><span
class="red"> <input type="hidden"
name="amount"
value="112"></span></li>\r\n
<li class="line"><span
class="linenumber">6</span><span
class="red"> <input type="hidden"
name="currency"
value="debit_base"></span></li>\r\n
<li class="line"><span
class="linenumber">7</span><span
class="red"> <input type="hidden"
name="custom"
value="comment"></span></li>\r\n
<li class="line"><span
class="linenumber">8</span><span
class="red"> <button type="submit">Pay
now!</button></span></li>\r\n
<li class="line"><span
class="linenumber">9</span><span
class="yellow"><form/></span></li>\r\n
</ul>\r\n </div>\r\n
</div>\r\n </div>\r\n <div
class="col-md-2">\r\n \r\n
</div>\r\n </div>\r\n </div>\r\n</div>\r\n\r\n<div
class="container">\r\n <div class="row">\r\n
<div class="col-md-12 mt-5">\r\n <h3
class="text-center">\r\n Simple form and instant payment
POST notifications\r\n </h3>\r\n </div>\r\n
</div>\r\n <div class="row">\r\n <div
class="col-md-4 mt-5">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/space.png"
class="w-25" alt="">\r\n <h5
class="mt-3">Fast start</h5>\r\n <p
class="mt-3">Register your account, go through verification
and start accepting
payments!</p>\r\n </div>\r\n </div>\r\n <div
class="col-md-4 mt-5">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/ipn.png"
class="w-25" alt="">\r\n <h5
class="mt-3">IPN system</h5>\r\n <p
class="mt-3">Get notifications about payments to your sites
built on any
CMS!</p>\r\n </div>\r\n </div>\r\n <div
class="col-md-4 mt-5">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/tool.png"
class="w-25" alt="">\r\n <h5
class="mt-3">Test mode</h5>\r\n <p
class="mt-3">Special test payment mode for developers without
using real
money!</p>\r\n </div>\r\n </div>\r\n </div>\r\n</div>\r\n\r\n<div
class="top-merchant mt-5">\r\n <div
class="container">\r\n <div
class="row">\r\n <div class="col-md-12 mt-5
mb-4">\r\n <h3
class="text-center">\r\n Get payments using the HTML
form or on website Just
Wallet\r\n </h3>\r\n </div>\r\n </div>\r\n <div
class="row">\r\n <div
class="col-md-4">\r\n <div
class="row">\r\n <div
class="col-md-12">\r\n <h4 class="text-primary
text-center">How to receive
payments?</h4>\r\n </div>\r\n <div
class="col-md-2 mt-4">\r\n <span
class="step-badge">1</span>\r\n
</div>\r\n <div class="col-md-10
mt-3">\r\n <p><strong>On your
site</strong> - just publish the HTML form and enter payment
parameters. User pay for purchase on a special
page</p>\r\n </div>\r\n </div>\r\n <div
class="row">\r\n <div class="col-md-2
mt-4">\r\n <span
class="step-badge-2">2</span>\r\n
</div>\r\n <div class="col-md-10
mt-3">\r\n <p><strong>Shops and
payment</strong> - add your store to our categories and the user pay
the purchase in your
account</p>\r\n </div>\r\n </div>\r\n <div
class="row">\r\n <div class="col-md-2
mt-4">\r\n <span
class="step-badge-2">3</span>\r\n
</div>\r\n <div class="col-md-10
mt-3">\r\n <p><strong>Invoicing
system</strong> - Enter the cost, the recipient and the description
of the invoice.
</p>\r\n </div>\r\n </div>\r\n </div>\r\n <div
class="col-md-8">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/escrow/img/icon/mac-merchant.png"
class="w-100"
alt="">\r\n </div>\r\n </div>\r\n </div>\r\n</div>\r\n\r\n<div
class="foot-merchant">\r\n <div
class="container">\r\n <div
class="row">\r\n <div class="col-md-12 mt-5
mb-4">\r\n <h3 class="text-center
text-white">\r\n Popular deposit methods for
users\r\n </h3>\r\n </div>\r\n <div
class="col-md-2 mt-4 mb-4">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/account/img/pay-icon/paypal.png"
class="w-50
win-img">\r\n </div>\r\n </div>\r\n <div
class="col-md-2 mt-4 mb-4">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/account/img/pay-icon/visa.png"
class="w-50
win-img">\r\n </div>\r\n </div>\r\n <div
class="col-md-2 mt-4 mb-4">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/account/img/pay-icon/btc.png"
class="w-50
win-img">\r\n </div>\r\n </div>\r\n <div
class="col-md-2 mt-4 mb-4">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/account/img/pay-icon/pm.png"
class="w-50
win-img">\r\n </div>\r\n </div>\r\n <div
class="col-md-2 mt-4 mb-4">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/account/img/pay-icon/advcash.png"
class="w-50
win-img">\r\n </div>\r\n </div>\r\n <div
class="col-md-2 mt-4 mb-4">\r\n <div
class="text-center">\r\n <img
src="http://justbtc.ideah.ru/assets/themes/account/img/pay-icon/swift.png"
class="w-50
win-img">\r\n </div>\r\n </div>\r\n <div
class="col-md-12 mt-4 mb-4">\r\n <div
class="text-center
text-white">\r\n <p>\r\n and other
metnods\r\n </p>\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n</div>\r\n\r\n<div
class="container">\r\n <div class="row">\r\n
<div class="col-md-12 mt-5">\r\n <h3
class="text-center">\r\n Documentation\r\n </h3>\r\n <p
class="text-center text-muted">\r\n POST form for
payment\r\n </p>\r\n </div>\r\n </div>\r\n <div
class="row">\r\n <div class="col-md-12
mt-4">\r\n <table class="table table-hover
table-responsive">\r\n <thead>\r\n <tr>\r\n <th
scope="col">Variable</th>\r\n <th
scope="col">Description</th>\r\n <th
scope="col">Conditions</th>\r\n <th
scope="col">Necessarily</th>\r\n </tr>\r\n </thead>\r\n <tbody>\r\n <tr>\r\n <th><code>merchant</code></th>\r\n <td>Merchant
ID in the system Just Wallet. Assigned to the merchant automatically after
adding a store to your account. Your store must be
moderated</td>\r\n <td>Not equal to
0</td>\r\n <td><strong>Yes</strong></td>\r\n </tr>\r\n <tr>\r\n <th><code>item_name</code></th>\r\n <td>Product
name or purpose of payment. This item is visible to the
payer</td>\r\n <td>Minimum number of characters 3, maximum
-
100</td>\r\n <td><strong>Yes</strong></td>\r\n </tr>\r\n <tr>\r\n <th><code>amount</code></th>\r\n <td>The
sum in any form. The sum is rounded to decimal places. The total amount
including commission will be calculated
automatically</td>\r\n <td>Sum is more than
1</td>\r\n <td><strong>Yes</strong></td>\r\n </tr>\r\n <tr>\r\n <th><code>currency</code></th>\r\n <td>Currency
of payment. Available currencies <code>debit_base</code>,
<code>debit_extra1</code>,
<code>debit_extra2</code>,
<code>debit_extra3</code>,
<code>debit_extra4</code>,
<code>debit_extra5</code></td>\r\n <td>Only
values from the
list</td>\r\n <td><strong>Yes</strong></td>\r\n </tr>\r\n <tr>\r\n <th><code>custom</code></th>\r\n <td>Comment
to the payment. For example, the order number in your store. This item is
not displayed to the buyer</td>\r\n <td>Maximum -
100</td>\r\n <td><strong>Yes</strong></td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </div>\r\n <div
class="col-md-12 mt-4">\r\n <p class="text-center
text-muted">\r\n IPN
notifications\r\n </p>\r\n </div>\r\n <div
class="col-md-12 mt-4">\r\n <table class="table
table-hover
table-responsive">\r\n <thead>\r\n <tr>\r\n <th
scope="col">Variable</th>\r\n <th
scope="col">Description</th>\r\n <th
scope="col">Example</th>\r\n </tr>\r\n </thead>\r\n <tbody>\r\n <tr>\r\n <th><code>$POST[''amount'']</code></th>\r\n <td>The
received amount without
commissions</td>\r\n <td><code>100.00</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''fee'']</code></th>\r\n <td>Fee
for payment. Paid by the buyer or merchant according to the
settings</td>\r\n <td><code>0.20</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''total'']</code></th>\r\n <td>Total
transaction amount including
commission</td>\r\n <td><code>100.20</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''currency'']</code></th>\r\n <td>Transaction
currency for which payment was
made</td>\r\n <td><code>debit_base</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''payer'']</code></th>\r\n <td>Buyer
username in the system Just
Wallet</td>\r\n <td><code>johndoe</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''receiver'']</code></th>\r\n <td>Merchant
username in the system Just
Wallet</td>\r\n <td><code>envato</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''status'']</code></th>\r\n <td>The
status of the transaction. Always Value
"Confirmed"</td>\r\n <td><code>Confirmed</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''date'']</code></th>\r\n <td>Transaction
date</td>\r\n <td><code>2018-01-09
03:11:07</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''id_transfer'']</code></th>\r\n <td>Unique
transaction number in the system Just
Wallet</td>\r\n <td><code>58954</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''merchant_name'']</code></th>\r\n <td>Merchant
store name in the system Just
Wallet</td>\r\n <td><code>Google
Inc</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''merchant_id'']</code></th>\r\n <td>Unique
number of merchant in the system Just
Wallet</td>\r\n <td><code>21</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''balance'']</code></th>\r\n <td>Available
merchant balance in transaction
currency</td>\r\n <td><code>2100.56</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''item_name'']</code></th>\r\n <td>Name
of paid goods</td>\r\n <td><code>Test
payment</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''custom'']</code></th>\r\n <td>Comment
on payment, formed by the merchant in the HTML
form</td>\r\n <td><code>INV
1452485</code></td>\r\n </tr>\r\n <tr>\r\n <th><code>$POST[''hash'']</code></th>\r\n <td>A
unique signature that is used to verify the validity of a notification. A
string join is created of the total amount, merchant password, date
transaction and transaction ID. The string is encrypted using an algorithm
MD5.</td>\r\n <td><code>C93D3BF7A7C4AFE94B64E30C2CE39F4F</code></td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </div>\r\n <div
class="col-md-12 mt-4">\r\n <p class="text-center
text-muted">\r\n Example of a notification handler in
PHP\r\n </p>\r\n </div>\r\n <div class="col-md-12
mt-4">\r\n <div class="card">\r\n <div
class="card-body">\r\n <div
class="form-group">\r\n <textarea
class="form-control" id="exampleFormControlTextarea1"
rows="12">// merchant password \r\n$merchant_password =
"t43t43t34t43t34t6545845";\r\n\r\n// transaction info\r\n$amount
= $_POST[''amount''];\r\n$fee = $_POST[''fee''];\r\n$total =
$_POST[''total''];\r\n$currency = $_POST[''currency''];\r\n$payer =
$_POST[''payer''];\r\n$receiver = $_POST[''receiver''];\r\n$status =
$_POST[''status''];\r\n$date = $_POST[''date''];\r\n$id_transfer =
$_POST[''id_transfer''];\r\n// Merchant info\r\n$merchant_name =
$_POST[''merchant_name''];\r\n$merchant_id =
$_POST[''merchant_id''];\r\n$balance = $_POST[''balance''];\r\n// Purchase
Information\r\n$item_name = $_POST[''item_name''];\r\n$custom =
$_POST[''custom''];\r\n// Verification of the transaction\r\n$hash =
$_POST[''hash''];\r\n\r\n$hash_string =
$total.'':''.$merchant_password.'':''.$date.'':''.$id_transfer;\r\n \r\n$user_hash
= strtoupper(md5($hash_string));\r\n\r\nif ($hash_string == $user_hash)
{\r\n\r\n echo "Confirmed!";\r\n\r\n} else {\r\n\r\n echo
"Dasabled!";\r\n\r\n}</textarea>\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n</div>\r\n\r\n<div
class="foot-merchant mt-5">\r\n <div
class="container">\r\n <div
class="row">\r\n <div class="col-md-12
mt-6">\r\n <h4 class="text-center
text-white">\r\n Create account and get
started\r\n </h4>\r\n </div>\r\n <div
class="col-md-12 mt-4 mb-5">\r\n <h4
class="text-center">\r\n <a href="#"
class="btn btn-outline-light btn-lg">Sign
up</a>\r\n </h4>\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n\r\n\r\n<?php
// echo $content;
?>";s:10:"indonesian";s:17:"<p>indonesian</p>";s:7:"russian";s:56:"<p>русиянский
язык в
действии</p>";s:18:"simplified-chinese";s:16:"<p>chine
erg</p>";s:7:"spanish";s:14:"<p>spanish</p>";s:7:"turkish";s:14:"<p>turkish</p>";}',
'1'),
(4, 'Help',
'a:7:{s:5:"dutch";s:12:"<p>dutch</p>";s:7:"english";s:144:"<div
class="header-st mb-4">\r\n<div
class="container">\r\n<div
class="row">\r\n<div
class="col-md-12">\r\n<h3>Help</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>";s:10:"indonesian";s:17:"<p>indonesian</p>";s:7:"russian";s:56:"<p>русиянский
язык в
действии</p>";s:18:"simplified-chinese";s:16:"<p>chine
erg</p>";s:7:"spanish";s:14:"<p>spanish</p>";s:7:"turkish";s:14:"<p>turkish</p>";}',
'1'),
(5, 'Terms of agreement',
'a:7:{s:5:"dutch";s:12:"<p>dutch</p>";s:7:"english";s:15352:"<div
class="header-st mb-4">\r\n <div
class="container">\r\n <div
class="row">\r\n <div
class="col-md-12">\r\n <h3>\r\n
Terms of agreement\r\n </h3>\r\n </div>\r\n
</div>\r\n </div>\r\n</div>\r\n\r\n<div
class="container">\r\n <div class="row">\r\n
<div class="col-md-12">\r\n <p
class="lead">\r\n
This license agreement (hereinafter referred to as the «Agreement»)
constitutes a contract between Denis A. Siminivtsev, who the author of and
the owner of the exclusive right to the «Just Wallet» (hereinafter
referred to as the «Copyright Owner»), and you (hereinafter referred to
as the «User»).\r\nThis Agreement contains definitions and conditions
under which the User can use «Just Wallet».\r\n
</p>\r\n
<h5>Terms and Definitions</h5>\r\n
<p>\r\n
All terms given in this section of the Agreement shall have the
following meaning for this Agreement only, and shall not be construed to
suggest otherwise when used in respect of the conditions set forth in this
Agreement.</br>\r\n<strong>Just Wallet</strong> – means
the software distributed on the site http://justwallet.pw/ or its
subdomains.</br>\r\n<strong>Program</strong> — means
the «Just Wallet».</br>\r\n<strong>Program-based
Derivative</strong> — means any program, work or information
created by the User or a third party with using the Program or any of its
parts.</br>\r\n<strong>Use of the Program</strong> —
means any actions related to operation of the Program according to its
purpose.</br>\r\n<strong>Domain Name</strong> — means a
unique alphanumeric name intended to identify a resource on the
Internet.</br>\r\n<strong>Server</strong> — means a
computer to which the Program is
installed.</br>\r\n<strong>Full License</strong> —
means the the right to Use the Program (one copy) on one Server provided by
the Copyright Owner to the User for unlimited
time.</br>\r\n<strong>Additional License</strong> —
means the time unlimited right to Use the Program on one Domain Name in
addition to the number of Domain Names declared while the Full License was
purchased.</br>\r\n<strong>Reseller</strong> — means a
legal entity or a private entrepreneur empowered to distribute the Full
Licenses and the Additional
Licenses.</br>\r\n<strong>Confidential
Information</strong> — means the contents of the Program (source
code), all the copies of the Program as well as all the derivative works
related to the Program, including, but not limited to, all the upgrades,
modifications.\r\n\r\n\r\n
</p>\r\n <h5>1.
General provisions</h5>\r\n
<p>\r\n The
User shall Use the Program within the bounds of this Agreement only.\r\nBy
Using the Program, the User thus consents to the conditions set forth in
this Agreement. If the User does not wish to be bound by the conditions of
this Agreement, he shall not Use the Program.</br>\r\nThe Copyright
Owner notifies the User that the Program is not sold to the User, but, in
accordance with this Agreement, the User gains the right to Use the Program
under a simple non-exclusive license.</br>\r\nEvery Use of the
Program is subject to this Agreement. Any Use of the Program or any of its
parts, which contradicts the conditions of this Agreement, is prohibited.
If the law of the User''s country makes a provision for a different order
of using similar products, the User has the right to Use the Program only
in the way and within the bounds stipulated by this Agreement.\r\n\r\n
</p>\r\n <h5>2. Grant of
license</h5>\r\n
<p>\r\n The
Copyright Owner provides the User with the Full License under a simple
non-exclusive license in the entire world only after the User pays the
compensation on the site https://justwallet.pw/or to the Reseller provided
that the User declares the number of Domain Names for which the Full
License is purchased and through which the Program will be available on the
Internet.\r\nThe Copyright Owner provides the User with the Additional
Storefront License under a simple non-exclusive license in the entire world
only after the User pays the compensation on the site
https://justwallet.pw/ or to the Reseller, provided that the User declares
for which his Full License the Additional License is obtained.\r\n\r\n
</p>\r\n <h5>3. Exclusive right and
limitations</h5>\r\n
<p>\r\n <strong>Exclusive
right:</strong></br>\r\nThe Copyright Owner owns personal
non-property copyrights and an exclusive right to the Program, as well as
to all the copies and all the derivative works, related to the Program,
including, but not limited to, to all the upgrades and
modifications.</br>\r\nThe Copyright Owner has the right
to:</br>\r\n- notify the User that the copy of the Program is illegal
and is used without the Full License or the Additional
License.</br>\r\n<strong>Limitations:</strong></br>\r\nThe
User has no right to:</br>\r\n- make copies of the Program and let a
third party copy the Program without obtaining an independent Full
License;</br>\r\n- use upgrades of the Program and/or the Program of
the versions that have been released by the Copyright Owner before the User
has purchased the Full License, as well as after the expiration of one
calendar year from the date on which the User has purchased the Full
License, unless the User has purchased a secondary right for such Full
License to use these upgrades of the Program and new versions of the
Program on the https://justwallet.pw/ website, and such right is not
active;</br>\r\n- make the Program available on a greater number of
Domain Names than declared while the Full License was purchased, if no
appropriate number of the Additional Licenses was obtained for
them;</br>\r\n- extract, excerpt or use any part of the Program to
create any Program-based Derivatives as well as provide such possibility to
a third party;</br>\r\n- sell, transfer, obligate, license,
sublicense, rent, lease, give for temporary use, yield or convey (by
selling, exchanging, giving as a gift, by law, or in any other way) the
Program, any of its copies (or any of its parts), the Full License or the
Additional License and other rights to them, partially or in full, to a
third party without a prior written consent of the Copyright
Owner;</br>\r\n- remove, hide, modify or make barely visible any
copyright, trademark or other proprietary notices contained within any part
of the Program without a prior written consent of the Copyright
Owner;</br>\r\n- prevent the Copyright Owner from obtaining
information about the Use of the Program.</br>\r\nThe User may not
remove, disable or modify the part of the Program source code that verifies
the Program authenticity and ascertains whether the User has the Full
License or the Additional License.\r\n\r\n
</p>\r\n <h5>4.
Confidentiality</h5>\r\n
<p>\r\n The User
pledges not to disclose Confidential Information, protect from and prevent
unauthorized disclosure of the Confidential Information, and take
appropriate measures to protect Confidential Information. If the
information, which is confidential according to this Agreement, becomes
available to a third party without a consent of the Copyright Owner, the
User agrees to indemnify the Copyright Owner for all suffered damages.\r\n
</p>\r\n <h5>5. Warranties and
limitations</h5>\r\n
<p>\r\n The Program
is provided "AS IS" with all possible malfunction and in the
state that is actual by the time the Copyright Owner provides the User with
the Full License or the Additional License.</br>\r\nUnder no
circumstances the Copyright Owner guarantees error-free and uninterrupted
performance of the Program and that the Program will meet the requirements
of the User as well as the Copyright Owner disclaims any other warranties
to the extent to which it is permitted by the effective law.\r\n\r\n
</p>\r\n <h5>6. Liability</h5>\r\n
<p>\r\n
The User assumes all the risks related to
the performance and the Use of the Program, including the risk of not
getting the expected profit, the risk of a software failure after the
Program is installed, etc.</br>\r\nUnder no circumstances the
Copyright Owner is liable to the User for any damages (including, but not
limited to, any loss of profits and confidential or other information, the
damages caused by an interruption of the business, loss of revenue,
turnover, business reputation or data, neglected business opportunities,
any indirect, incidental, special, punitive or consequential damages)
related to the Use of the Program or impossibility to Use the
Program.</br>\r\nIn the event that the law of the User''s country
concedes no limitation of liability, or the liability of the Copyright
Owner is recognized by the competent court, the Copyright Owner will be
liable only for actual damage incurred from Using the Program if the damage
is caused by a tort of the Copyright Owner, or if the damage is caused by
the reasons that the Copyright Owner knew or should have known. The maximum
amount of liability of the Copyright Owner is limited to the amount of the
compensation that the User paid for one Full License.</br>\r\nThe
limitations of liability of the Copyright Owner that are specified in this
section of the Agreement apply to the Program and all associated
objects.\r\n\r\n\r\n
</p>\r\n <h5>7. Termination of the
License and Agreement</h5>\r\n
<p>\r\n The
Agreement is effective until terminated. The Agreement and the Full License
together with the appropriate Additional Licenses are also terminated
immediately after the User violates any part of this Agreement without any
additional notice from the Copyright Owner. And the User consents to
immediately remove the Program together with all copies, modifications and
upgrades, and any Program-based Derivatives.</br>\r\nThe territory
for this Agreement shall be the entire world. The User has the right to
terminate the Full License together with the appropriate Additional
Licenses at any time by discontinuing the Agreement and removing the
Program together with all its copies, modifications and upgrades, and
Program-based Derivatives, along with sending an appropriate notification
to the Copyright Owner. The Agreement will be deemed terminated from the
moment the Copyright Owner receives the notification from the User.\r\n\r\n
</p>\r\n <h5>8. Final
Provisions</h5>\r\n
<p>\r\n This
Agreement complies with the effective law of the Russian Federation. The
appropriate law to interpret this Agreement and all relationships coming
from the scope of the Agreement is the substantive and the adjective law of
the Russian Federation..</br>\r\nIf any condition of this Agreement
for any reason becomes unenforceable, or is voided or declared invalid by
the competent court, then it is regarded as an omission from the text of
this Agreement, which, however, shall by no means affect the legitimacy and
validity of the other conditions.</br>\r\nThe section headings in the
text of the Agreement are for convenience only and have no independent
legal force, and shall not be interpreted in relation to the conditions of
the Agreement.</br>\r\nThe User acknowledges that he has read this
Agreement carefully and understood it completely, and agrees to accept its
terms and conditions.</br>\r\nThe Copyright Owner may unilaterally
change this Agreement. The User is notified of the changes through a notice
on the site https://justwallet.pw/ where the text of the changes is
published. The changes in the conditions of the Agreement shall come into
force on the date of publishing on the site https://justwallet.pw/, unless
otherwise is specified in the publication, and become mandatory for
acceptance and satisfaction by the User for further Use of the
Program.</br>\r\nThe User acknowledges that the Copyright Owner may
suffer damage if the conditions of this Agreement are not respected, and
therefore the User agrees that the Copyright Owner has the right to use any
form of protecting the violated rights and legitimate interests, including
the direct appeal to the appropriate court without a necessity to comply
with the claim settlement procedure.</br>\r\nAny dispute arising out
or in connection with this Agreement, including any question regarding its
interpretation, execution, termination or validity shall be finally settled
by arbitration under the Rules of the International Commercial Arbitration
Court at the Chamber of Commerce and Industry of the Russian Federation
http://mkas.tpprf.ru/ru/reglamentmkas.php (hereinafter referred to as the
"Rules"), which Rules are deemed to be incorporated by reference
into this section. The arbitration panel shall consist of one (1)
arbitrator selected in accordance with the Rules. The language to be used
in the arbitral proceeding shall be Russian. The governing law of the
Agreement shall be the substantive law of Russian Federation. The
arbitration shall be held in Moscow, Russian Federation. The injunctive
relief for the subject of dispute may be only suspension of recovery on the
basis of the enforced document questioned by the plaintiff or any other
document under which penalties are recovered on non-acceptable basis. The
plaintiff shall bear its own and the other Party''s costs associated with
the resolution or arbitration of any dispute, and all fees and other costs
of the arbitration proceeding shall be paid by the plaintiff. The award
rendered by the arbitration shall be final and binding upon both Parties
and judgment upon the award may be entered in any court having jurisdiction
thereof.</br>\r\nThe Parties acknowledge the legal validity of the
documents sent by email. The documents sent by the Copyright Owner are
considered created in the proper written form if they are sent from
connect@justwallet.pw and/or manager@justwallet.pw.</br>\r\nThe
Program is protected by the law of the Russian Federation and international
legislation on copyright and intellectual property.\r\n<p>© 2017
Denis A. Siminivtsev</p>\r\n\r\n
</p>\r\n </div>\r\n
</div>\r\n</div>";s:10:"indonesian";s:17:"<p>indonesian</p>";s:7:"russian";s:56:"<p>русиянский
язык в
действии</p>";s:18:"simplified-chinese";s:16:"<p>chine
erg</p>";s:7:"spanish";s:14:"<p>spanish</p>";s:7:"turkish";s:14:"<p>turkish</p>";}',
'1');
INSERT INTO `pages` (`id`, `name`, `content`, `translite`) VALUES
(6,
'Privacy policy',
'a:7:{s:5:"dutch";s:12:"<p>dutch</p>";s:7:"english";s:15348:"<div
class="header-st mb-4">\r\n <div
class="container">\r\n <div
class="row">\r\n <div
class="col-md-12">\r\n <h3>\r\n
Privacy policy\r\n </h3>\r\n </div>\r\n
</div>\r\n </div>\r\n</div>\r\n\r\n<div
class="container">\r\n <div class="row">\r\n
<div class="col-md-12">\r\n <p
class="lead">\r\n
This license agreement (hereinafter referred to as the «Agreement»)
constitutes a contract between Denis A. Siminivtsev, who the author of and
the owner of the exclusive right to the «Just Wallet» (hereinafter
referred to as the «Copyright Owner»), and you (hereinafter referred to
as the «User»).\r\nThis Agreement contains definitions and conditions
under which the User can use «Just Wallet».\r\n
</p>\r\n
<h5>Terms and Definitions</h5>\r\n
<p>\r\n
All terms given in this section of the Agreement shall have the
following meaning for this Agreement only, and shall not be construed to
suggest otherwise when used in respect of the conditions set forth in this
Agreement.</br>\r\n<strong>Just Wallet</strong> – means
the software distributed on the site http://justwallet.pw/ or its
subdomains.</br>\r\n<strong>Program</strong> — means
the «Just Wallet».</br>\r\n<strong>Program-based
Derivative</strong> — means any program, work or information
created by the User or a third party with using the Program or any of its
parts.</br>\r\n<strong>Use of the Program</strong> —
means any actions related to operation of the Program according to its
purpose.</br>\r\n<strong>Domain Name</strong> — means a
unique alphanumeric name intended to identify a resource on the
Internet.</br>\r\n<strong>Server</strong> — means a
computer to which the Program is
installed.</br>\r\n<strong>Full License</strong> —
means the the right to Use the Program (one copy) on one Server provided by
the Copyright Owner to the User for unlimited
time.</br>\r\n<strong>Additional License</strong> —
means the time unlimited right to Use the Program on one Domain Name in
addition to the number of Domain Names declared while the Full License was
purchased.</br>\r\n<strong>Reseller</strong> — means a
legal entity or a private entrepreneur empowered to distribute the Full
Licenses and the Additional
Licenses.</br>\r\n<strong>Confidential
Information</strong> — means the contents of the Program (source
code), all the copies of the Program as well as all the derivative works
related to the Program, including, but not limited to, all the upgrades,
modifications.\r\n\r\n\r\n
</p>\r\n <h5>1.
General provisions</h5>\r\n
<p>\r\n The
User shall Use the Program within the bounds of this Agreement only.\r\nBy
Using the Program, the User thus consents to the conditions set forth in
this Agreement. If the User does not wish to be bound by the conditions of
this Agreement, he shall not Use the Program.</br>\r\nThe Copyright
Owner notifies the User that the Program is not sold to the User, but, in
accordance with this Agreement, the User gains the right to Use the Program
under a simple non-exclusive license.</br>\r\nEvery Use of the
Program is subject to this Agreement. Any Use of the Program or any of its
parts, which contradicts the conditions of this Agreement, is prohibited.
If the law of the User''s country makes a provision for a different order
of using similar products, the User has the right to Use the Program only
in the way and within the bounds stipulated by this Agreement.\r\n\r\n
</p>\r\n <h5>2. Grant of
license</h5>\r\n
<p>\r\n The
Copyright Owner provides the User with the Full License under a simple
non-exclusive license in the entire world only after the User pays the
compensation on the site https://justwallet.pw/or to the Reseller provided
that the User declares the number of Domain Names for which the Full
License is purchased and through which the Program will be available on the
Internet.\r\nThe Copyright Owner provides the User with the Additional
Storefront License under a simple non-exclusive license in the entire world
only after the User pays the compensation on the site
https://justwallet.pw/ or to the Reseller, provided that the User declares
for which his Full License the Additional License is obtained.\r\n\r\n
</p>\r\n <h5>3. Exclusive right and
limitations</h5>\r\n
<p>\r\n <strong>Exclusive
right:</strong></br>\r\nThe Copyright Owner owns personal
non-property copyrights and an exclusive right to the Program, as well as
to all the copies and all the derivative works, related to the Program,
including, but not limited to, to all the upgrades and
modifications.</br>\r\nThe Copyright Owner has the right
to:</br>\r\n- notify the User that the copy of the Program is illegal
and is used without the Full License or the Additional
License.</br>\r\n<strong>Limitations:</strong></br>\r\nThe
User has no right to:</br>\r\n- make copies of the Program and let a
third party copy the Program without obtaining an independent Full
License;</br>\r\n- use upgrades of the Program and/or the Program of
the versions that have been released by the Copyright Owner before the User
has purchased the Full License, as well as after the expiration of one
calendar year from the date on which the User has purchased the Full
License, unless the User has purchased a secondary right for such Full
License to use these upgrades of the Program and new versions of the
Program on the https://justwallet.pw/ website, and such right is not
active;</br>\r\n- make the Program available on a greater number of
Domain Names than declared while the Full License was purchased, if no
appropriate number of the Additional Licenses was obtained for
them;</br>\r\n- extract, excerpt or use any part of the Program to
create any Program-based Derivatives as well as provide such possibility to
a third party;</br>\r\n- sell, transfer, obligate, license,
sublicense, rent, lease, give for temporary use, yield or convey (by
selling, exchanging, giving as a gift, by law, or in any other way) the
Program, any of its copies (or any of its parts), the Full License or the
Additional License and other rights to them, partially or in full, to a
third party without a prior written consent of the Copyright
Owner;</br>\r\n- remove, hide, modify or make barely visible any
copyright, trademark or other proprietary notices contained within any part
of the Program without a prior written consent of the Copyright
Owner;</br>\r\n- prevent the Copyright Owner from obtaining
information about the Use of the Program.</br>\r\nThe User may not
remove, disable or modify the part of the Program source code that verifies
the Program authenticity and ascertains whether the User has the Full
License or the Additional License.\r\n\r\n
</p>\r\n <h5>4.
Confidentiality</h5>\r\n
<p>\r\n The User
pledges not to disclose Confidential Information, protect from and prevent
unauthorized disclosure of the Confidential Information, and take
appropriate measures to protect Confidential Information. If the
information, which is confidential according to this Agreement, becomes
available to a third party without a consent of the Copyright Owner, the
User agrees to indemnify the Copyright Owner for all suffered damages.\r\n
</p>\r\n <h5>5. Warranties and
limitations</h5>\r\n
<p>\r\n The Program
is provided "AS IS" with all possible malfunction and in the
state that is actual by the time the Copyright Owner provides the User with
the Full License or the Additional License.</br>\r\nUnder no
circumstances the Copyright Owner guarantees error-free and uninterrupted
performance of the Program and that the Program will meet the requirements
of the User as well as the Copyright Owner disclaims any other warranties
to the extent to which it is permitted by the effective law.\r\n\r\n
</p>\r\n <h5>6. Liability</h5>\r\n
<p>\r\n
The User assumes all the risks related to
the performance and the Use of the Program, including the risk of not
getting the expected profit, the risk of a software failure after the
Program is installed, etc.</br>\r\nUnder no circumstances the
Copyright Owner is liable to the User for any damages (including, but not
limited to, any loss of profits and confidential or other information, the
damages caused by an interruption of the business, loss of revenue,
turnover, business reputation or data, neglected business opportunities,
any indirect, incidental, special, punitive or consequential damages)
related to the Use of the Program or impossibility to Use the
Program.</br>\r\nIn the event that the law of the User''s country
concedes no limitation of liability, or the liability of the Copyright
Owner is recognized by the competent court, the Copyright Owner will be
liable only for actual damage incurred from Using the Program if the damage
is caused by a tort of the Copyright Owner, or if the damage is caused by
the reasons that the Copyright Owner knew or should have known. The maximum
amount of liability of the Copyright Owner is limited to the amount of the
compensation that the User paid for one Full License.</br>\r\nThe
limitations of liability of the Copyright Owner that are specified in this
section of the Agreement apply to the Program and all associated
objects.\r\n\r\n\r\n
</p>\r\n <h5>7. Termination of the
License and Agreement</h5>\r\n
<p>\r\n The
Agreement is effective until terminated. The Agreement and the Full License
together with the appropriate Additional Licenses are also terminated
immediately after the User violates any part of this Agreement without any
additional notice from the Copyright Owner. And the User consents to
immediately remove the Program together with all copies, modifications and
upgrades, and any Program-based Derivatives.</br>\r\nThe territory
for this Agreement shall be the entire world. The User has the right to
terminate the Full License together with the appropriate Additional
Licenses at any time by discontinuing the Agreement and removing the
Program together with all its copies, modifications and upgrades, and
Program-based Derivatives, along with sending an appropriate notification
to the Copyright Owner. The Agreement will be deemed terminated from the
moment the Copyright Owner receives the notification from the User.\r\n\r\n
</p>\r\n <h5>8. Final
Provisions</h5>\r\n
<p>\r\n This
Agreement complies with the effective law of the Russian Federation. The
appropriate law to interpret this Agreement and all relationships coming
from the scope of the Agreement is the substantive and the adjective law of
the Russian Federation..</br>\r\nIf any condition of this Agreement
for any reason becomes unenforceable, or is voided or declared invalid by
the competent court, then it is regarded as an omission from the text of
this Agreement, which, however, shall by no means affect the legitimacy and
validity of the other conditions.</br>\r\nThe section headings in the
text of the Agreement are for convenience only and have no independent
legal force, and shall not be interpreted in relation to the conditions of
the Agreement.</br>\r\nThe User acknowledges that he has read this
Agreement carefully and understood it completely, and agrees to accept its
terms and conditions.</br>\r\nThe Copyright Owner may unilaterally
change this Agreement. The User is notified of the changes through a notice
on the site https://justwallet.pw/ where the text of the changes is
published. The changes in the conditions of the Agreement shall come into
force on the date of publishing on the site https://justwallet.pw/, unless
otherwise is specified in the publication, and become mandatory for
acceptance and satisfaction by the User for further Use of the
Program.</br>\r\nThe User acknowledges that the Copyright Owner may
suffer damage if the conditions of this Agreement are not respected, and
therefore the User agrees that the Copyright Owner has the right to use any
form of protecting the violated rights and legitimate interests, including
the direct appeal to the appropriate court without a necessity to comply
with the claim settlement procedure.</br>\r\nAny dispute arising out
or in connection with this Agreement, including any question regarding its
interpretation, execution, termination or validity shall be finally settled
by arbitration under the Rules of the International Commercial Arbitration
Court at the Chamber of Commerce and Industry of the Russian Federation
http://mkas.tpprf.ru/ru/reglamentmkas.php (hereinafter referred to as the
"Rules"), which Rules are deemed to be incorporated by reference
into this section. The arbitration panel shall consist of one (1)
arbitrator selected in accordance with the Rules. The language to be used
in the arbitral proceeding shall be Russian. The governing law of the
Agreement shall be the substantive law of Russian Federation. The
arbitration shall be held in Moscow, Russian Federation. The injunctive
relief for the subject of dispute may be only suspension of recovery on the
basis of the enforced document questioned by the plaintiff or any other
document under which penalties are recovered on non-acceptable basis. The
plaintiff shall bear its own and the other Party''s costs associated with
the resolution or arbitration of any dispute, and all fees and other costs
of the arbitration proceeding shall be paid by the plaintiff. The award
rendered by the arbitration shall be final and binding upon both Parties
and judgment upon the award may be entered in any court having jurisdiction
thereof.</br>\r\nThe Parties acknowledge the legal validity of the
documents sent by email. The documents sent by the Copyright Owner are
considered created in the proper written form if they are sent from
connect@justwallet.pw and/or manager@justwallet.pw.</br>\r\nThe
Program is protected by the law of the Russian Federation and international
legislation on copyright and intellectual property.\r\n<p>© 2017
Denis A. Siminivtsev</p>\r\n\r\n
</p>\r\n </div>\r\n
</div>\r\n</div>";s:10:"indonesian";s:17:"<p>indonesian</p>";s:7:"russian";s:56:"<p>русиянский
язык в
действии</p>";s:18:"simplified-chinese";s:16:"<p>chine
erg</p>";s:7:"spanish";s:14:"<p>spanish</p>";s:7:"turkish";s:14:"<p>turkish</p>";}',
'1'),
(7, 'General Escrow Instructions',
'a:7:{s:5:"dutch";s:12:"<p>dutch</p>";s:7:"english";s:167:"<div
class="header-st mb-4">\r\n<div
class="container">\r\n<div
class="row">\r\n<div
class="col-md-12">\r\n<h3>General Escrow
Instructions</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>";s:10:"indonesian";s:17:"<p>indonesian</p>";s:7:"russian";s:56:"<p>русиянский
язык в
действии</p>";s:18:"simplified-chinese";s:16:"<p>chine
erg</p>";s:7:"spanish";s:14:"<p>spanish</p>";s:7:"turkish";s:14:"<p>turkish</p>";}',
'1'),
(8, 'Page not found',
'a:7:{s:5:"dutch";s:0:"";s:7:"english";s:448:"<div
class="header-st mb-4">\r\n<div
class="container">\r\n<div
class="row">\r\n<div
class="col-md-12">\r\n<h3>Page not
founs</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div
class="container mt-5">\r\n <div
class="row">\r\n <div class="col-md-12
text-center">\r\n <i class="icon-exclamation icons
text-danger h1"></i>\r\n <h3
class="mt-4">This page has been deleted or does not
exist</h3>\r\n <h1
class="mt-4"><strong>404</strong></h1>\r\n </div>\r\n </div>\r\n</div>";s:10:"indonesian";s:0:"";s:7:"russian";s:0:"";s:18:"simplified-chinese";s:0:"";s:7:"spanish";s:0:"";s:7:"turkish";s:0:"";}',
'1');
-- --------------------------------------------------------
--
--
Структура таблицы `settings`
--
CREATE TABLE IF NOT EXISTS
`settings` (
`id` int(10) unsigned NOT NULL,
`name` varchar(128) NOT
NULL,
`input_type`
enum('input','textarea','radio','dropdown','timezones') CHARACTER SET
latin1 NOT NULL,
`options` text COMMENT 'Use for radio and dropdown:
key|value on each line',
`is_numeric` enum('0','1') NOT NULL DEFAULT '0'
COMMENT 'forces numeric keypad on mobile devices',
`show_editor`
enum('0','1') NOT NULL DEFAULT '0',
`input_size`
enum('large','medium','small') DEFAULT NULL,
`translate` enum('0','1')
NOT NULL DEFAULT '0',
`help_text` varchar(256) DEFAULT NULL,
`validation` varchar(128) NOT NULL,
`sort_order` tinyint(3) unsigned NOT
NULL,
`label` varchar(128) NOT NULL,
`value` text COMMENT 'If translate
is 1, just start with your default language',
`last_update` datetime
DEFAULT NULL,
`updated_by` int(11) unsigned DEFAULT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `settings`
--
INSERT INTO `settings` (`id`, `name`,
`input_type`, `options`, `is_numeric`, `show_editor`, `input_size`,
`translate`, `help_text`, `validation`, `sort_order`, `label`, `value`,
`last_update`, `updated_by`) VALUES
(1, 'site_name', 'input', NULL, '0',
'0', 'large', '0', NULL, 'required|trim|min_length[3]|max_length[128]', 10,
'Site Name', 'Just Wallet', '2018-03-11 16:14:45', 1),
(2,
'per_page_limit', 'dropdown',
'10|10\r\n25|25\r\n50|50\r\n75|75\r\n100|100', '1', '0', 'small', '0',
NULL, 'required|trim|numeric', 50, 'Items Per Page', '10', '2018-03-11
16:14:45', 1),
(3, 'meta_keywords', 'input', NULL, '0', '0', 'large', '0',
'Comma-seperated list of site keywords', 'trim', 20, 'Meta Keywords',
'these, are, keywords test', '2018-03-11 16:14:45', 1),
(4,
'meta_description', 'textarea', NULL, '0', '0', 'large', '0', 'Short
description describing your site.', 'trim', 30, 'Meta Description', 'This
is the site description.', '2018-03-11 16:14:45', 1),
(5, 'site_email',
'input', NULL, '0', '0', 'medium', '0', 'Email address all emails will be
sent from.', 'required|trim|valid_email', 40, 'Site Email',
'info@justwallet.pw', '2018-03-11 16:14:45', 1),
(6, 'timezones',
'timezones', NULL, '0', '0', 'medium', '0', NULL, 'required|trim', 60,
'Timezone', 'UTC', '2018-03-11 16:14:45', 1),
(7, 'com_transfer', 'input',
NULL, '1', '0', 'medium', '0', NULL, 'required|trim|numeric', 70, 'Transer
fee, %', '10', '2018-03-11 16:14:45', 1),
(8, 'com_invoice', 'input', NULL,
'1', '0', 'medium', '0', NULL, 'required|trim|numeric', 80, 'Invoice fee,
%', '10', '2018-03-11 16:14:45', 1),
(10, 'google_secret', 'input', NULL,
'0', '0', 'medium', '0', NULL, 'required|trim', 90, 'reCAPTCHA secret',
'6LfLHlAUAAAAAB2Q8lTj7VJwqPHy-o9AlEMDpYIB', '2018-03-11 16:14:45', 1),
(11,
'phone', 'input', NULL, '0', '0', 'medium', '0', NULL, 'numeric', 100,
'Phone', '18007589898', '2018-03-11 16:14:45', 1),
(12, 'skype', 'input',
NULL, '0', '0', 'medium', '0', NULL, 'trim', 110, 'Skype', 'justwallet',
'2018-03-11 16:14:45', 1),
(13, 'twilio_sid', 'input', NULL, '0', '0',
'medium', '0', NULL, 'trim', 120, 'Twilio SID', '', '2018-03-11 16:14:45',
1),
(14, 'twilio_token', 'input', NULL, '0', '0', 'medium', '0', NULL,
'trim', 130, 'Twilio token', '', '2018-03-11 16:14:45', 1),
(15,
'twilio_phone', 'input', NULL, '0', '0', NULL, '0', NULL,
'required|trim|numeric', 140, 'Twilio phone number', '', '2018-03-11
16:14:45', 1),
(17, 'google_site_key', 'input', NULL, '0', '0', 'medium',
'0', NULL, 'required|trim', 150, 'reCAPTCHA site key',
'6LfLHlAUAAAAADHyTMVkh5YbXmidS40105lffpat', NULL, NULL),
(18, 'fixer',
'input', NULL, '0', '0', 'medium', '0', NULL, 'required|trim', 160, 'API
Access Key Fixer.io', 'e8f3f37007e56bad6c94277580de4448', NULL, NULL);
--
--------------------------------------------------------
--
--
Структура таблицы `settings_deposit`
--
CREATE TABLE IF
NOT EXISTS `settings_deposit` (
`id` int(10) unsigned NOT NULL,
`name`
varchar(300) NOT NULL,
`fee_fix` decimal(10,2) NOT NULL,
`fee`
decimal(10,2) NOT NULL,
`start_verify` enum('0','1') NOT NULL,
`standart_verify` enum('0','1') NOT NULL,
`expanded_verify` enum('0','1')
NOT NULL,
`status` enum('0','1') NOT NULL,
`debit_base` enum('0','1')
NOT NULL,
`debit_extra1` enum('0','1') NOT NULL,
`debit_extra2`
enum('0','1') NOT NULL,
`debit_extra3` enum('0','1') NOT NULL,
`debit_extra4` enum('0','1') NOT NULL,
`debit_extra5` enum('0','1') NOT
NULL,
`minimum_debit_base` decimal(10,2) NOT NULL,
`maximum_debit_base`
decimal(10,2) NOT NULL,
`minimum_debit_extra1` decimal(10,2) NOT NULL,
`maximum_debit_extra1` decimal(10,2) NOT NULL,
`minimum_debit_extra2`
decimal(10,2) NOT NULL,
`maximum_debit_extra2` decimal(10,2) NOT NULL,
`minimum_debit_extra3` decimal(10,2) NOT NULL,
`maximum_debit_extra3`
decimal(10,2) NOT NULL,
`minimum_debit_extra4` decimal(10,2) NOT NULL,
`maximum_debit_extra4` decimal(10,2) NOT NULL,
`minimum_debit_extra5`
decimal(10,2) NOT NULL,
`maximum_debit_extra5` decimal(10,2) NOT NULL,
`ac_debit_base` text NOT NULL,
`ac_debit_extra1` text NOT NULL,
`ac_debit_extra2` text NOT NULL,
`ac_debit_extra3` text NOT NULL,
`ac_debit_extra4` text NOT NULL,
`ac_debit_extra5` text NOT NULL,
`api_value1` varchar(100) NOT NULL,
`api_value2` varchar(100) NOT NULL
)
ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
--
-- Дамп
данных таблицы `settings_deposit`
--
INSERT INTO
`settings_deposit` (`id`, `name`, `fee_fix`, `fee`, `start_verify`,
`standart_verify`, `expanded_verify`, `status`, `debit_base`,
`debit_extra1`, `debit_extra2`, `debit_extra3`, `debit_extra4`,
`debit_extra5`, `minimum_debit_base`, `maximum_debit_base`,
`minimum_debit_extra1`, `maximum_debit_extra1`, `minimum_debit_extra2`,
`maximum_debit_extra2`, `minimum_debit_extra3`, `maximum_debit_extra3`,
`minimum_debit_extra4`, `maximum_debit_extra4`, `minimum_debit_extra5`,
`maximum_debit_extra5`, `ac_debit_base`, `ac_debit_extra1`,
`ac_debit_extra2`, `ac_debit_extra3`, `ac_debit_extra4`, `ac_debit_extra5`,
`api_value1`, `api_value2`) VALUES
(1, 'PayPal', 0.50, 0.00, '1', '1', '1',
'0', '1', '1', '0', '0', '0', '0', 1.00, 500.00, 1.00, 15000.00, 5.00,
2000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', '', '', '', '', '', '',
''),
(2, 'Perfect Money', 0.01, 0.00, '1', '1', '1', '0', '1', '0', '1',
'0', '0', '0', 0.01, 500.00, 0.00, 0.00, 0.01, 400.00, 0.00, 0.00, 0.00,
0.00, 0.00, 0.00, '', '', '', '', '', '', '', ''),
(3, 'ADV Cash', 0.01,
0.00, '1', '1', '1', '0', '1', '1', '1', '0', '0', '0', 0.01, 500.00, 0.10,
15000.00, 0.01, 500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', '', '', '',
'', '', '', ''),
(4, 'Payeer', 0.01, 0.00, '1', '1', '1', '0', '1', '1',
'1', '0', '0', '0', 0.01, 100.00, 0.01, 100.00, 0.01, 100.00, 0.00, 0.00,
0.00, 0.00, 0.00, 0.00, '', '', '', '', '', '', '', ''),
(5, 'Credit card
via Skrill', 0.01, 10.00, '1', '1', '1', '0', '0', '0', '1', '0', '0', '0',
0.01, 500.00, 1.00, 15000.00, 0.01, 500.00, 0.00, 0.00, 0.00, 0.00, 0.00,
0.00, '', '', '', '', '', '', '', ''),
(6, 'Credit card via Paygol', 0.10,
0.00, '1', '1', '1', '0', '1', '0', '1', '0', '0', '0', 1.00, 500.00, 0.00,
0.00, 1.00, 500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', '', '', '', '',
'', '', ''),
(7, 'SWIFT', 10.00, 5.00, '1', '1', '1', '0', '1', '1', '1',
'1', '1', '1', 100.00, 5000.00, 100.00, 5000.00, 100.00, 5000.00, 100.00,
5000.00, 100.00, 5000.00, 100.00, 5000.00, '', '', '', '', '', '', '',
''),
(8, 'Bank of America / Local bank transfer', 10.00, 5.00, '1', '1',
'1', '0', '1', '0', '0', '0', '0', '0', 100.00, 30000.00, 0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', '', '', '', '', '', '',
''),
(9, 'Bitcoin and other crypto-currencies', 0.10, 0.00, '1', '1', '1',
'0', '1', '1', '0', '0', '0', '0', 0.10, 100.00, 0.10, 100.00, 0.00, 0.00,
0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', '', '', '', '', '', '', ''),
(10,
'Blockchain', 0.01, 0.00, '1', '1', '1', '0', '1', '1', '0', '0', '0', '0',
0.10, 500.00, 10.00, 500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00,
0.00, '', '', '', '', '', '', '', '');
--
--------------------------------------------------------
--
--
Структура таблицы `settings_withdrawal`
--
CREATE TABLE IF
NOT EXISTS `settings_withdrawal` (
`id` int(10) unsigned NOT NULL,
`name` varchar(300) NOT NULL,
`fee_fix` decimal(10,2) NOT NULL,
`fee`
decimal(10,0) NOT NULL,
`terms` text NOT NULL,
`start_verify`
enum('0','1') NOT NULL,
`standart_verify` enum('0','1') NOT NULL,
`expanded_verify` enum('0','1') NOT NULL,
`status` enum('0','1') NOT
NULL,
`debit_base` enum('0','1') NOT NULL,
`debit_extra1` enum('0','1')
NOT NULL,
`debit_extra2` enum('0','1') NOT NULL,
`debit_extra3`
enum('0','1') NOT NULL,
`debit_extra4` enum('0','1') NOT NULL,
`debit_extra5` enum('0','1') NOT NULL,
`minimum_debit_base` decimal(10,2)
NOT NULL,
`maximum_debit_base` decimal(10,2) NOT NULL,
`minimum_debit_extra1` decimal(10,2) NOT NULL,
`maximum_debit_extra1`
decimal(10,2) NOT NULL,
`minimum_debit_extra2` decimal(10,2) NOT NULL,
`maximum_debit_extra2` decimal(10,2) NOT NULL,
`minimum_debit_extra3`
decimal(10,2) NOT NULL,
`maximum_debit_extra3` decimal(10,2) NOT NULL,
`minimum_debit_extra4` decimal(10,2) NOT NULL,
`maximum_debit_extra4`
decimal(10,2) NOT NULL,
`minimum_debit_extra5` decimal(10,2) NOT NULL,
`maximum_debit_extra5` decimal(10,2) NOT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `settings_withdrawal`
--
INSERT INTO `settings_withdrawal`
(`id`, `name`, `fee_fix`, `fee`, `terms`, `start_verify`,
`standart_verify`, `expanded_verify`, `status`, `debit_base`,
`debit_extra1`, `debit_extra2`, `debit_extra3`, `debit_extra4`,
`debit_extra5`, `minimum_debit_base`, `maximum_debit_base`,
`minimum_debit_extra1`, `maximum_debit_extra1`, `minimum_debit_extra2`,
`maximum_debit_extra2`, `minimum_debit_extra3`, `maximum_debit_extra3`,
`minimum_debit_extra4`, `maximum_debit_extra4`, `minimum_debit_extra5`,
`maximum_debit_extra5`) VALUES
(1, 'PayPal', 2.00, 0, '1 business day',
'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 0.00, 0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(2, 'Credit card', 10.00,
5, '1 business daye', '0', '1', '1', '0', '1', '1', '1', '0', '0', '0',
5.00, 3000.00, 1.00, 100.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00,
0.00),
(3, 'Bitcoin', 0.00, 0, '1 business day', '0', '1', '1', '0', '1',
'0', '1', '0', '0', '0', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 0.00),
(4, 'SWIFT', 0.00, 0, '1-5 business days', '0',
'1', '1', '0', '1', '1', '0', '0', '0', '0', 100.00, 50000.00, 0.00, 0.00,
0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(5, 'Skrill', 0.00, 0, '1
business day', '0', '1', '1', '0', '1', '0', '1', '0', '0', '0', 0.00,
0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(6,
'Payza', 0.00, 0, '1 business day', '0', '1', '1', '0', '1', '0', '0', '0',
'0', '0', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00,
0.00),
(7, 'ADV Cash', 0.00, 0, '1 business day', '0', '0', '1', '0', '1',
'0', '0', '0', '0', '0', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 0.00),
(8, 'Perfect Money', 0.00, 0, '1 business day',
'0', '1', '0', '0', '1', '0', '0', '0', '1', '0', 0.00, 0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00);
--
--------------------------------------------------------
--
--
Структура таблицы `sms_template`
--
CREATE TABLE IF NOT
EXISTS `sms_template` (
`id` int(10) unsigned NOT NULL,
`title` text
NOT NULL,
`message` text NOT NULL,
`status` enum('0','1') NOT NULL
)
ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
--
-- Дамп
данных таблицы `sms_template`
--
INSERT INTO `sms_template`
(`id`, `title`, `message`, `status`) VALUES
(1, 'Confirm login', 'Your code
[CODE]', '1'),
(2, 'Signed in', 'Signed in to your account [IP_ADDRESS]',
'1'),
(3, 'Create ticket', 'For you a new ticket has been created on the
site', '1'),
(4, 'New comment in ticket', 'New comment is available for the
ticket [CODE_TICKET]', '1'),
(5, 'Ticket closed', 'Ticket
[CODE_TICKET] was closed and unavailable for comment.', '1'),
(6,
'Verification request verified', 'Your account has been successfully
verified!', '1'),
(7, 'Verification request rejected', 'We checked your
documents and could not verify your account!', '1'),
(8, 'Withdrawal
pending', 'The withdrawal, amount equal to [SUM] [CUR], were deducted from
your account.', '1'),
(9, 'Completed currency exchange', 'You successfully
exchanged [SUM_1] [CUR_1] on [SUM_2] [CUR_2].', '1'),
(10, 'Open dispute',
'User [CLAIMANT] opened a dispute about the transaction ID
[ID_TRANSACTION]', '1'),
(11, 'New comment for dispute', 'New comment was
added for the dispute ID [ID_DISPUTE].', '1'),
(12, 'Claim opened', 'Your
dispute ID [ID_DISPUTE] was transferred to the claim!', '1'),
(13, 'Claim
rejected', 'Claim ID [ID_DISPUTE] rejected', '1'),
(14, 'Claim satisfied',
'Claim ID [ID_DISPUTE] satisfied', '1'),
(15, 'Success money transfer',
'You have successfully transferred [SUM] [CUR] to the user [RECEIVER]',
'1'),
(16, 'Withdrawal is confirmed', 'Withdrawal of funds in the amount of
[SUM] [CUR] was confirmed!', '1'),
(17, 'Withdrawal of funds denied',
'Withdrawal of funds in the amount of [SUM] [CUR] was rejected', '1'),
(18,
'Invoice pending', 'Received new invoice for the amount of [SUM] [CUR].',
'1'),
(19, 'Invoice rejected', 'Invoice ID [ID_INVOICE] was rejected.',
'1'),
(20, 'Notice to receive', 'Notice to receive funds[SUM] [CUR]',
'1');
-- --------------------------------------------------------
--
--
Структура таблицы `tickets`
--
CREATE TABLE IF NOT EXISTS
`tickets` (
`id` int(10) unsigned NOT NULL,
`code` varchar(100) NOT
NULL,
`date` datetime NOT NULL,
`user` varchar(100) NOT NULL,
`status` enum('0','1','2') NOT NULL,
`title` text NOT NULL,
`message`
text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `tickets_comments`
--
CREATE TABLE IF
NOT EXISTS `tickets_comments` (
`id` int(10) unsigned NOT NULL,
`id_ticket` varchar(100) NOT NULL,
`date` datetime NOT NULL,
`user`
varchar(100) NOT NULL,
`role` enum('0','1') NOT NULL,
`comment` text
NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `transactions`
--
CREATE TABLE IF NOT
EXISTS `transactions` (
`id` int(10) unsigned NOT NULL,
`time` datetime
NOT NULL,
`type` enum('1','2','3','4','5') NOT NULL,
`sum`
decimal(10,2) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`fee`
decimal(10,2) NOT NULL,
`currency` varchar(128) NOT NULL,
`status`
enum('1','2','3','4','5') NOT NULL,
`sender` varchar(128) NOT NULL,
`receiver` varchar(128) NOT NULL,
`user_comment` text NOT NULL,
`admin_comment` text NOT NULL,
`label` varchar(128) NOT NULL,
`ip_address` varchar(128) NOT NULL,
`protect` varchar(100) NOT NULL
DEFAULT 'none',
`protect_attempts` int(10) NOT NULL,
`merchant` int(10)
NOT NULL DEFAULT '0',
`payer_fee` enum('0','1') NOT NULL DEFAULT '0'
)
ENGINE=InnoDB AUTO_INCREMENT=379 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS
`users` (
`id` int(10) unsigned NOT NULL,
`username` varchar(30) NOT
NULL,
`password` char(128) NOT NULL,
`salt` char(128) NOT NULL,
`first_name` varchar(32) NOT NULL,
`last_name` varchar(32) NOT NULL,
`email` varchar(256) NOT NULL,
`language` varchar(64) DEFAULT NULL,
`is_admin` enum('0','1') NOT NULL DEFAULT '0',
`status` enum('0','1') NOT
NULL DEFAULT '1',
`deleted` enum('0','1') NOT NULL DEFAULT '0',
`validation_code` varchar(50) DEFAULT NULL COMMENT 'Temporary code for
opt-in registration',
`created` datetime NOT NULL,
`updated` datetime
NOT NULL,
`verify_status` enum('0','1','2') NOT NULL,
`paypal`
varchar(100) NOT NULL,
`card` varchar(50) NOT NULL,
`bitcoin`
varchar(100) NOT NULL,
`skrill` varchar(100) NOT NULL,
`payza`
varchar(100) NOT NULL,
`advcash` varchar(100) NOT NULL,
`perfect_m`
varchar(100) NOT NULL,
`swift` text NOT NULL,
`company` varchar(150)
NOT NULL,
`country` varchar(100) NOT NULL,
`zip` varchar(50) NOT NULL,
`city` varchar(100) NOT NULL,
`address_1` text NOT NULL,
`address_2`
text NOT NULL,
`time` int(11) NOT NULL DEFAULT '0',
`debit_base`
decimal(10,2) NOT NULL DEFAULT '0.00',
`debit_extra1` decimal(10,2)
DEFAULT '0.00',
`debit_extra2` decimal(10,2) NOT NULL DEFAULT '0.00',
`debit_extra3` decimal(10,2) NOT NULL DEFAULT '0.00',
`debit_extra4`
decimal(10,2) NOT NULL DEFAULT '0.00',
`debit_extra5` decimal(10,2) NOT
NULL DEFAULT '0.00',
`fraud` enum('0','1') NOT NULL,
`phone`
varchar(50) NOT NULL,
`method_login` enum('1','2','3','4') NOT NULL
DEFAULT '1',
`login_token` varchar(100) NOT NULL,
`2fa_login`
varchar(100) NOT NULL,
`login_status` enum('1','2') NOT NULL,
`ip_address` varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=22
DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы
`users`
--
INSERT INTO `users` (`id`, `username`, `password`, `salt`,
`first_name`, `last_name`, `email`, `language`, `is_admin`, `status`,
`deleted`, `validation_code`, `created`, `updated`, `verify_status`,
`paypal`, `card`, `bitcoin`, `skrill`, `payza`, `advcash`, `perfect_m`,
`swift`, `company`, `country`, `zip`, `city`, `address_1`, `address_2`,
`time`, `debit_base`, `debit_extra1`, `debit_extra2`, `debit_extra3`,
`debit_extra4`, `debit_extra5`, `fraud`, `phone`, `method_login`,
`login_token`, `2fa_login`, `login_status`, `ip_address`) VALUES
(1,
'admin',
'0d78e6e276579ee85380e3297b9625a64d762bf91e8dc67b3b4c504877b876a03847f063602b72dd97396bcb18647267a3f0b08fd9e1a259dda4e8fc470b8100',
'6c9c5fa19c68d2ecd276005ac52746d8e2149e094aa732b2aaecec765be3cee1f07ffc1e989ceef8cebb8b629ac5752d4d5251948e7dbb22ec096eadb5da9fab',
'Admin', 'Adminovin', 'justwalletpw@gmail.com', 'english', '1', '1', '0',
NULL, '2013-01-01 00:00:00', '2018-04-01 10:28:44', '2',
'kantemitova88@gmail.com', '5213240056895689',
'1KZyPTm3AD6cP9oCFYcDMZ3G3tNMhgdxo7', 'useradmin@yandex.ru',
'justwallet@payza.com', 'advcash@gmail.com', 'U12202556', 'Bank Name:
First Century Bank\r\nRouting (ABA): 061120084\r\nAccount
Number: 4012556950739\r\nAccount Type:
CHECKING\r\nBeneficiary Name: Just Digital', 'JDT USA 236', 'Russia',
'394000 288', 'New York 26', 'Pushina street, 18, app.48 289', '2 Line
address ewfrw 200', 1515701679, 812.00, 591.22, 407.63, 50.70, 10.80, 0.00,
'1', '79525448459', '1', '', '', '1', '109.106.142.235');
--
--------------------------------------------------------
--
--
Структура таблицы `verification`
--
CREATE TABLE IF NOT
EXISTS `verification` (
`id` int(10) unsigned NOT NULL,
`code`
varchar(100) NOT NULL,
`date` datetime NOT NULL,
`id_card` text NOT
NULL,
`id_address` text NOT NULL,
`status` enum('0','1','2') NOT NULL,
`comment` text NOT NULL,
`user` varchar(150) NOT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `vouchers`
--
CREATE TABLE IF NOT EXISTS
`vouchers` (
`id` int(11) unsigned NOT NULL,
`code` varchar(100) NOT
NULL,
`date_creature` datetime NOT NULL,
`creator` varchar(200) NOT
NULL,
`amount` decimal(10,2) NOT NULL,
`currency` varchar(100) NOT
NULL,
`date_activation` datetime NOT NULL,
`activator` varchar(200) NOT
NULL,
`status` enum('1','2','3') NOT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
--
-- Индексы
сохранённых таблиц
--
--
-- Индексы таблицы
`captcha`
--
ALTER TABLE `captcha`
ADD PRIMARY KEY (`captcha_id`),
ADD
KEY `word` (`word`);
--
-- Индексы таблицы `carts`
--
ALTER
TABLE `carts`
ADD PRIMARY KEY (`id`);
--
-- Индексы
таблицы `ci_sessions`
--
ALTER TABLE `ci_sessions`
ADD PRIMARY KEY
(`id`),
ADD KEY `ci_sessions_timestamp` (`timestamp`);
--
--
Индексы таблицы `currencys`
--
ALTER TABLE `currencys`
ADD
PRIMARY KEY (`id`);
--
-- Индексы таблицы
`disputes`
--
ALTER TABLE `disputes`
ADD PRIMARY KEY (`id`);
--
--
Индексы таблицы `disputes_comment`
--
ALTER TABLE
`disputes_comment`
ADD PRIMARY KEY (`id`);
--
-- Индексы
таблицы `emails`
--
ALTER TABLE `emails`
ADD PRIMARY KEY (`id`),
ADD KEY `name` (`name`),
ADD KEY `title` (`title`),
ADD KEY `created`
(`created`),
ADD KEY `read` (`read`),
ADD KEY `read_by` (`read_by`),
ADD KEY `email` (`email`(78));
--
-- Индексы таблицы
`email_templates`
--
ALTER TABLE `email_templates`
ADD PRIMARY KEY
(`id`);
--
-- Индексы таблицы `events`
--
ALTER TABLE
`events`
ADD PRIMARY KEY (`id`);
--
-- Индексы таблицы
`invoices`
--
ALTER TABLE `invoices`
ADD PRIMARY KEY (`id`);
--
--
Индексы таблицы `items`
--
ALTER TABLE `items`
ADD PRIMARY
KEY (`id`);
--
-- Индексы таблицы `login_attempts`
--
ALTER
TABLE `login_attempts`
ADD KEY `ip` (`ip`);
--
-- Индексы
таблицы `merchants`
--
ALTER TABLE `merchants`
ADD PRIMARY KEY
(`id`);
--
-- Индексы таблицы
`merchants_categories`
--
ALTER TABLE `merchants_categories`
ADD PRIMARY
KEY (`id`);
--
-- Индексы таблицы
`merchant_categories`
--
ALTER TABLE `merchant_categories`
ADD PRIMARY
KEY (`id`);
--
-- Индексы таблицы `orders`
--
ALTER TABLE
`orders`
ADD PRIMARY KEY (`id`);
--
-- Индексы таблицы
`pages`
--
ALTER TABLE `pages`
ADD PRIMARY KEY (`id`);
--
--
Индексы таблицы `settings`
--
ALTER TABLE `settings`
ADD
PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`),
ADD KEY
`updated_by` (`updated_by`);
--
-- Индексы таблицы
`settings_deposit`
--
ALTER TABLE `settings_deposit`
ADD PRIMARY KEY
(`id`);
--
-- Индексы таблицы `settings_withdrawal`
--
ALTER
TABLE `settings_withdrawal`
ADD PRIMARY KEY (`id`);
--
-- Индексы
таблицы `sms_template`
--
ALTER TABLE `sms_template`
ADD PRIMARY
KEY (`id`);
--
-- Индексы таблицы `tickets`
--
ALTER TABLE
`tickets`
ADD PRIMARY KEY (`id`);
--
-- Индексы таблицы
`tickets_comments`
--
ALTER TABLE `tickets_comments`
ADD PRIMARY KEY
(`id`);
--
-- Индексы таблицы `transactions`
--
ALTER TABLE
`transactions`
ADD PRIMARY KEY (`id`);
--
-- Индексы
таблицы `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `username` (`username`);
--
-- Индексы
таблицы `verification`
--
ALTER TABLE `verification`
ADD PRIMARY
KEY (`id`);
--
-- Индексы таблицы `vouchers`
--
ALTER TABLE
`vouchers`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT для
сохранённых таблиц
--
--
-- AUTO_INCREMENT для
таблицы `captcha`
--
ALTER TABLE `captcha`
MODIFY `captcha_id`
bigint(13) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=117;
--
--
AUTO_INCREMENT для таблицы `carts`
--
ALTER TABLE `carts`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT для
таблицы `currencys`
--
ALTER TABLE `currencys`
MODIFY `id` int(11)
NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT для
таблицы `disputes`
--
ALTER TABLE `disputes`
MODIFY `id` int(10)
unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT
для таблицы `disputes_comment`
--
ALTER TABLE `disputes_comment`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=53;
--
-- AUTO_INCREMENT для
таблицы `emails`
--
ALTER TABLE `emails`
MODIFY `id` int(10)
unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT
для таблицы `email_templates`
--
ALTER TABLE `email_templates`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=32;
--
-- AUTO_INCREMENT для
таблицы `events`
--
ALTER TABLE `events`
MODIFY `id` int(10)
unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=284;
--
-- AUTO_INCREMENT
для таблицы `invoices`
--
ALTER TABLE `invoices`
MODIFY `id`
int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
--
AUTO_INCREMENT для таблицы `items`
--
ALTER TABLE `items`
MODIFY `id` int(100) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT для
таблицы `merchants`
--
ALTER TABLE `merchants`
MODIFY `id` int(10)
unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT
для таблицы `merchants_categories`
--
ALTER TABLE
`merchants_categories`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT для
таблицы `merchant_categories`
--
ALTER TABLE `merchant_categories`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT для таблицы
`orders`
--
ALTER TABLE `orders`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT для
таблицы `pages`
--
ALTER TABLE `pages`
MODIFY `id` int(10) NOT
NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT для
таблицы `settings`
--
ALTER TABLE `settings`
MODIFY `id` int(10)
unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT
для таблицы `settings_deposit`
--
ALTER TABLE `settings_deposit`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT для
таблицы `settings_withdrawal`
--
ALTER TABLE `settings_withdrawal`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT для таблицы
`sms_template`
--
ALTER TABLE `sms_template`
MODIFY `id` int(10) unsigned
NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT для
таблицы `tickets`
--
ALTER TABLE `tickets`
MODIFY `id` int(10)
unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT
для таблицы `tickets_comments`
--
ALTER TABLE `tickets_comments`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT для
таблицы `transactions`
--
ALTER TABLE `transactions`
MODIFY `id`
int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=379;
--
--
AUTO_INCREMENT для таблицы `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT для
таблицы `verification`
--
ALTER TABLE `verification`
MODIFY `id`
int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
--
AUTO_INCREMENT для таблицы `vouchers`
--
ALTER TABLE `vouchers`
MODIFY `id` int(11) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=5;
/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;